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.
Sub testloop()
Dim cell As Range
For Each cell In Range("H2:H5000")
If cell > 3 Then
cell.Offset(0, 6).Value = cell
End If
Next cell
End Sub
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?
Bookmarks