Can Range.Find search a Cells' Text property?
 

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?

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?

Can Range.Find search a Cells' Text property?
 

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.

On Sun, 24 Aug 2003 14:02:00 -0700, "clarence_rollins"
wrote:

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?