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