4 replies
There are several ways you can get a loop like this to exit. I would recommend the following:
''''''''''''''''''''''''''''''''''
Do Until (use the appropriate syntax for ACTIVE CELL = A2 here)
(Enter all the code here that you want to have executed during the loop)
Loop
''''''''''''''''''''''''''''''''''
This method will check the active cell at the start of the loop, and the loop will terminate if the condition is true.
I hope this helps. Good luck!
by abarnes70
Something a little more reliable would be to use an IF command to control the deletion:
if activecell.address="$A$1" then
else
activecell.clearcontents
end if
The deletion command will depend on what you are deleting, ie cells, their contents, their formats etc.
HTH
by seeker46
by seeker46
This discussion is closed to new replies.
Trending Software posts
Sort by Trending