View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Henry[_10_] Henry[_10_] is offline
external usenet poster
 
Posts: 5
Default Reversing the order of a For-Each loop action?

To all you knowledgeable and helpful people,

I'm using a For-Each loop to run through a named Range and delete all
non-blank Rows. This only removes alternate Rows. I know it should be done
from the bottom of the Range upwards. Is it possible to get a For-Each loop
to start at the bottom of the Range and work upwards? I know how to do it in
a For-Next loop, but Step -1 obviously won't work if the loop counter is
pointing at the top Row to start with! The size of the Range, on entering
the loop, is indeterminate.

TIA
Henry