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