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

To the best of my knowledge, no.

--
Regards,
Tom Ogilvy



"ExcelMonkey" wrote in message
...
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