Can Range.Find search a Cells' Text property?

  • Thread starter Thread starter clarence_rollins
  • Start date Start date
C

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?
 
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.
 
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.
 
Back
Top