| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text String and select cell address where it is found?
actually, it would be
Dim rng as Range, mySearch as Range set rng = Range(mySearch.Address) but that seems like the long way around the block (use a range to get a range) unless you are using the address of mySearch to use on a different sheet and specify the same location. -- Regards, Tom Ogilvy wrote in message oups.com... Doesn't Dim rng as Range rng = Range(mySearch.Address) work for you? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
| to find the text and to know that particular cell address | Excel Programming | |||
| Highlight found text string in cell? | Excel Programming | |||
Threaded Mode
