View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Count backwards with a for next loop

For i = 4 to 1 step -1

"Gus Chuch" wrote:

Dont you count backwards with a for next loop using the following
For i = 1 To 4
Sheet1.Cells(i, 1) = i
Next i
I cant seem to get it to work. I also tried using a Step -1 but no luck
Any ideas ?
--
thank You
Gus