Excel vba last row in 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 resized / moved)
Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _
      Cells(lLastRow, lLastColumn))

Similar codes

0 vote247 views1 answer
Vba check 32 or 64 bit
VBA
0 vote250 views1 answer
Vbscript check if string is empty
VBA
1 vote249 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote243 views1 answer
Default host vbox address
VBA
0 vote231 views1 answer
Vba type variable
VBA
0 vote246 views1 answer
Regex numeric digits
VBA
1 vote238 views2 answers
Vba string to date
VBA
0 vote227 views1 answer
Vba copy paste value only
VBA
0 vote251 views1 answer
Find if year is leap year vb
VBA
0 vote242 views1 answer
Excel vba chrw max value
VBA