vba last row
'1 is the Column in which the last row is being searched lRow = Thisworkbook.Sheets("List").Cells(Rows.Count, 1).End(xlUp).Row
excel vba last row
Dim rRange As Range Dim rDuplicate As Range Set rRange = ActiveSheet.UsedRange lFirstRow = rRange.Row lLastRow = rRange.Rows.Count + rRange.Row - 1 lFirstColumn = rRange.Column lLastColumn = rRange.Columns.Count + rRange.Column - 1 ' New reference to current range (can be resized / moved) Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _ Cells(lLastRow, lLastColumn))
excel vba last row of range
Dim rRange As Range Dim rDuplicate As Range Set rRange = ActiveSheet.UsedRange lFirstRow = rRange.Row lLastRow = rRange.Rows.Count + rRange.Row - 1 lFirstColumn = rRange.Column lLastColumn = rRange.Columns.Count + rRange.Column - 1 ' New reference to current range (can be truncated) Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _ Cells(lLastRow, lLastColumn))