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

0 vote318 views1 answer
Vba ternary
VBA
-1 vote265 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote286 views1 answer
Vba option button selected
VBA
0 vote281 views1 answer
Find days in month vba
VBA
0 vote302 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
1 vote307 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote304 views1 answer
Excel vba clear filter
VBA
0 vote298 views1 answer
Vba sheet hide unhide
VBA
0 vote292 views1 answer
Remove series name from legendvbnet
VBA
0 vote296 views1 answer
Vbnet chart make 0 gridline line different color
VBA