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?