Hi all,
I need code in a macro to search a variable string called Tit in column A of a sheet and if found get the row number.
My search should NOT be case sensitive and NOT exact match. I can use Instr function but then I have to loop through 3000 lines.
I have tried using wild cards:
Tit = range("B1")
Set Rng = Range("A1:A3000")
If Application.WorksheetFunction.CountIf(Rng, "*" & Tit & "*") > 0 Then
Row = Application.WorksheetFunction.Match(Tit, Rng, 0) (or Rv = Application.WorksheetFunction.Match("*" & Titolo "*", Rng, 0)
Else: End if
But no luck.
Appreciate your help