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

1 vote163 views1 answer
Excel vba get column name from number
VBA
0 vote164 views1 answer
Vbs write file
VBA
0 vote164 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote168 views1 answer
Vba array dimensions
VBA
1 vote190 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote165 views1 answer
Not allow form to be resized
VBA
1 vote151 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote160 views1 answer
Remove last 8 characters from string vb
VBA
5 votes187 views1 answer
Excel vba how to unit test vba code
VBA
0 vote119 views10 answers
Vba excel create event log
VBA