| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search range, find value in another col in corresponding row | Excel Discussion (Misc queries) | |||
| File Property Keyword Search | Excel Discussion (Misc queries) | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| How to find text in a range of cells? | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
![Wild Bill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
