Step Through Cells In Range

[jstevens]

Is it possible to read each cell in a RangeName from the bottom up. Similar to using Step -1?

Thanks,
John

[StuartR]

Assume you have a range called rngStuart
You can refer the cells in this range as
Range("rngStuart").Cells(n)
To access them all in reverse order you could use a construct like

Code: Select all

For n = Range("rngStuart").Cells.Count To 1 Step -1
     Debug.Print  Range("rngStuart").Cells(n).Value
Next n

[jstevens]

Stuart,

Thank you for your suggestion. I was able to incorporate it into my code.

Regards,
John