Tuesday, September 3, 2013

Get to last row in a column

How to get to the last row in a column using VBA:

Dim LastRow As Long
LastRow = Range("I" & Rows.Count).End(xlUp).Row

'I is the column and LastRow is a variable

No comments:

Post a Comment