I think what you are wanting would be a for i = 4 to 1 step - 1
you were trying to step backward but increment at the same time.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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