Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub PrintNumbersInReverseOrder()
- Dim lastRow As Integer
- lastRow = Cells(Rows.count, 1).End(xlUp).row
- ReDim numsArr(0 To lastRow - 1)
- For r = 1 To lastRow
- numsArr(r - 1) = Cells(r, 1)
- Next
- For i = UBound(numsArr) To 0 Step -1
- Debug.Print numsArr(i)
- Next
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement