deleting rows, endless loop maybe ?
Perhaps this is a dumb Q, but a brief experiment looking at ranges in
Immediate Window causes me to ask this question. Will the following
(with correct syntax) cause an endless loop since the cells shifting
into the range will be empty?
range = a1:a10 (for example)
for each empty cell in range, delete the row
a11, a12, etc are in fact empty.
Thanks!
|