Looping from range bottom

[terriertrip]

How do you loop FROM the bottom (last row). I know how to from row(1). I've tried using

Please Login or Register  to view this content.

but it still starts from the row(1). Any help's appreciated.

[Mumps1]

That should work. It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file

[davesexcel]

If you are starting at the last row, and want that cell to equal cell(.offset(1) then that cell will equal nothing, because there would be nothing in the cell below the last cell.

If you were trying to equal the cell above then you would need to offset(-1,0). Negative offset is going up.

[terriertrip]

Thanks Dave! That's what I needed. Just set to offset(2,0) and works like a charm.