View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dick[_2_] dick[_2_] is offline
external usenet poster
 
Posts: 6
Default 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!