General discussion
August 26, 2003 at 08:11 AM
seeker46

How to enter a test for cell A1 in a do…while loop

by seeker46 . Updated 23 years, 1 month ago

In my Excel Macro I loop through a spreadsheet and delete cells containing specific text. I would like to end the macro before the loop reaches cell A1 (I begin the macro by making cell A2 active). I don’t want the text in A1 deleted. How do I tell the macro to exit the do…while loop when it encounters cell A1?

This discussion is locked

All Comments