| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text using wildcards?
I have a macro that performs a loop through a column of text, until th ActiveCell equals a certain value. Below is the relevant section o code. How can I test for any cell that has UserID anywhere in it, suc that it would find text like NWUserId or UserID2? Do Until ActiveCell = "UserID" i = i + 1 ActiveCell.Offset(1, 0).Range("A1").Select Loop Thank Yo -- ackur ----------------------------------------------------------------------- ackurv's Profile: http://www.excelforum.com/member.php...fo&userid=1552 View this thread: http://www.excelforum.com/showthread.php?threadid=27093 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for text "beginning with" "containing" wildcards | Excel Worksheet Functions | |||
| how do I use wildcards to search between a range of product numb. | Setting up and Configuration of Excel | |||
| How do I search without wildcards? | Excel Discussion (Misc queries) | |||
| using wildcards on text | Excel Worksheet Functions | |||
| Using wildcards within a text box | Excel Programming | |||
Threaded Mode
