Look at Find and Findnext in VBA help.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Brian Matlack"
wrote in message
news:Brian.Matlack.27ux3a_1147710004.9878@excelfor um-nospam.com...

Hi!
I have a set of data (Range A1:C5750) where some cells in column A
contain the text "work ctr". at each of these cells I need to perform
several steps (starting at that cell) and then go on to the next cell
that contains "work ctr". and do the exact same thing.
The data is several thousand rows long and column A contains cells with
numbers, dates, text and blanks (data is not continuous). I think this
would be a loop thing but I'm not experienced with them so I'm not sure
what method would be best.
Any help or direction would be great! THANKS!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=542167