View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clarence_rollins clarence_rollins is offline
external usenet poster
 
Posts: 1
Default 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?