I have a macro that loops For i = 2 To 17, where row 17 is the last row of data.

Dim i as Integer
For i = 2 To 17
Do something
Next i

However, my last row of data changes everyday. How can I modify the macro such that I can loop it until the last row?