Hi,
Instr( cells(1,1).value, "searchstring" )
rgds,
Lazzzx

"Souris" skrev i meddelelsen
...
I want to find a special string like "Total" in some cells.

I tried to use find which is a methed of range, but it works only with
value
and match which only works in the spreadsheet, but not VBA coding.


Are there any function that can find a sub string of the cell?

Your help is great appreciated,