View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rod Jones[_2_] Rod Jones[_2_] is offline
external usenet poster
 
Posts: 1
Default For...next in reverse

Is it possible to do a for each..next loop through a range in reverse e.g

dim grCell as range

for each grCell in sheets("sheet1").range("A100:A1")
...do something here
next grCell

I've look through the help files but no luck.
Thank you for your time