Can Range.Find search a Cells' Text property?

[clarence_rollins]

I am searching a column of Cells formatted
as "XX"0, "YY"0, etc.

If the Cells' Value property is "23" the Cells' Text
property is "XX23".

Can Range.Find() compare its 'What' parameter against a
Cells' Text property?

 

[Tom Ogilvy]

I doubt it, but why not just search for 23. If you want cells specifically
formatted that way, then you could check the numberformat property of each
cell found and continue to search until you found 23 with that numberformat.

 

[Wild Bill]

I suppose you already visited Help:
LookIn Optional Variant. Can be one of the following XlFindLookIn
constants: xlFormulas, xlValues, or xlComments

Looks like you'll have to walk it.