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?

Do you need to add
loop until ActiveCell.Text <> "'Completed" (you said you wanted the first example of "not started"... shouldn't that be at the top of the loop? i.e.

Do While ActiveCell.Text <> "Not started"
ActiveCell.Offset(1).Select
Loop


Plus you had an additional ' in front of the "completed""...

Originally Posted by HBF

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?