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,