Excel vba first 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 truncated)
Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _
      Cells(lLastRow, lLastColumn))

Similar codes

0 vote277 views1 answer
Vba change named range address
VBA
0 vote245 views1 answer
Excel vba open browser
VBA
0 vote270 views1 answer
Vba shape transparent
VBA
1 vote266 views1 answer
Excel vba make cell visible
VBA
3 votes263 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote279 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote216 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote291 views1 answer
Excel vba to lower case
VBA
0 vote286 views1 answer
Vba listbox remove all items
VBA
5 votes299 views1 answer
Excel vba low word from Long Integer
VBA