run a loop from bottom - up?

[losmi8]

Hi all, by definition loops fun from the first row and down. I have a set of data that i need to run a loop from the bottom (5000th row) to the top (2nd row).

here is the sample loop that would work if i needed 2nd row to 5000th.

Please Login or Register  to view this content.

so what would i change in this loop for it to run in reverse? from the very bottom to the very top (2nd row)?


ps. does it matter that cell is in all small caps? when i type Cells, it automatically makes it small cap. does that matter at all?

[shg]

Please Login or Register  to view this content.

[losmi8]

Thank you. That does work!

How would I do it if I didn't know how many rows there were? If it always changes? Here is what I am trying to do, even though I do not understand why I would use .End(xlUp) instead of .End(xlDown) ? Can someone please explain this? I know I am using the correct one, but what does .End(xlUp) do after the Rows.Count statement? Doesn't it just return the value all the way to the top of the column?

Anyway, here is what I have and it isn't working:

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

The & concatenates the two strings. For instance, If LR had returned 3098, then "H2" & LR would create the string: H23098; the above will create: H2:H3098

[losmi8]

So if I find the last row with LR, do I still need to use the

Please Login or Register  to view this content.

Or is there a way for me to code it something like,

Please Login or Register  to view this content.

would that be correct as well?

[protonLeah]

Yes, it would
Also,
Cells(Rows.Count, "H") goes to the bottom of column H i.e., H65536
End(xlUp) does the same as ctrl + up arrow, i.e. moves up the the first used cell
.Row returns the row number