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 vote309 views1 answer
Excel named range sum
VBA
4 votes293 views2 answers
Vba create folder if not exist
VBA
0 vote296 views2 answers
Get excel file from email attachment in vba
VBA
0 vote276 views1 answer
Returns an array from function vba
VBA
1 vote284 views1 answer
Vba compile error object required
VBA
0 vote299 views2 answers
Open url from vba
VBA
7 votes312 views1 answer
Vba array declaration
VBA
3 votes296 views1 answer
Vba http request json
VBA
1 vote278 views1 answer
Close form vba
VBA
0 vote263 views1 answer
Excel vba open browser
VBA