Find Method

[ExcelMonkey]

Using the Find Method there is a setting for Lookin:

expression.Find(What, After, LookIn, LookAt, SearchOrder,
SearchDirection, MatchCase, MatchByte)

which can either be:
xlFormulas, xlValues, or xlComments

Is it possible to use all three settings simultaneously
during a search?

Thanks

 

[Tom Ogilvy]

To the best of my knowledge, no.