Excel vba first column 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

5 votes242 views1 answer
Excel-vba get integer high byte
VBA
0 vote228 views1 answer
Excel vba cell on change
VBA
0 vote238 views1 answer
Vba html document reference
VBA
3 votes220 views1 answer
Vba make long from two shorts
VBA
0 vote228 views1 answer
Sort dictionary by key vba
VBA
0 vote229 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote211 views1 answer
Docker vboxmanage not found
VBA
1 vote212 views1 answer
Vba compile error object required
VBA
0 vote272 views1 answer
Vba excel parser xml
VBA
0 vote225 views1 answer
Internet explorer reference vba
VBA