search for something like.....


Posted by Russell on January 30, 2002 12:49 PM

I use a macro that I have written......

Range("F1").Select
Do Until ActiveCell = "City Ledger"
ActiveCell.Offset(1, 0).Select
Loop

my problem is this works MOST of the time, but once in a while the cell will have one extra character following the string such as a * or a / or something of the sort, how can I write this to select those cells that start with City Ledger, no matter what follows afterwards.

Your help is greatly appreciated.



Posted by Larry on January 30, 2002 1:03 PM

***** A couple of options:

ActiveCell like "City Ledger*"

or

left(ActiveCell,11) = "City Ledger"

*****