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

Similar codes

2 votes255 views2 answers
Excel vba if sunday or staurday
VBA
5 votes261 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote293 views1 answer
Visual basic cmd
VBA
0 vote273 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote233 views1 answer
Excel vba StartUpPosition
VBA
1 vote247 views2 answers
Vba string length
VBA
1 vote227 views1 answer
Vba reverse string
VBA
0 vote224 views1 answer
Excel VBA web scraping
VBA
15 votes475 views1 answer
Excel vba wait
VBA
5 votes268 views1 answer
Vba low word from Long Integer
VBA