excel vba first and last row and column in range

The solution for “excel vba first and last row and column in range” can be found here. The following code will assist you in solving the problem.

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))

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts