Can Range.Find search 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.
--
Regards,
Tom Ogilvy
clarence_rollins wrote in message
...
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?
|