Hi All, I'm trying to use (*) symbol in 'countifs' function in vba. But, i'm getting error for below. Range("c2").FormulaLocal = "=countif(" & Range("b2:b7").Address() & "," & Range("b2").Address(rowabsolute:=False) & "," & Range("a2:a7").Address() & "," & "*cms*" & ")" Could you please suggest me, how to use (*) symbol in above formula.
How to use Wild characters (*) symbol in countifs in vba
Answers
Sai,
There are better places than here for this type of question (since it is really programming), however a simple Google search yielded this (among a whole bunch more):
http://www.mrexcel.com/forum/excel-questions/493619-using-wildcard-*-visual-basic-applications-excel.html