View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Loop backwards through selection?

Hi,

One way,

Loops backwards from A100 to A1 writing the numbers 100 to 1 in each cell

Sub standard()
For x = 100 To 1 Step -1
Cells(x, 1).Value = x
Next
End Sub

Mike

"ppsa" wrote:

Hi,

Can someone please tell me how to loop from the last cell to the first in a
selection?

Thank you