Simple Loop Help Please
 

I have a column which contains text which has either "Completed" or "Not
Started". I sort by that column, then want to find the first cell
containing "Not Started"

Do While ActiveCell.Text < "'Completed"
ActiveCell.Offset(1).Select
Loop

This doesn't work - what am I doing wrong?


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=545065