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 vote211 views1 answer
String contins in vba
VBA
0 vote171 views1 answer
How to sort datagridview in vb.net
VBA
0 vote224 views1 answer
Excel vba protect sheet
VBA
0 vote219 views1 answer
Send webhook vbscript
VBA
0 vote224 views1 answer
Selecttoken em vbnet e json
VBA
0 vote191 views1 answer
Vba apostrophe chr
VBA
1 vote226 views1 answer
Vba loop through files in folder
VBA
0 vote199 views1 answer
Vba option button selected
VBA
-1 vote215 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote216 views1 answer
Visual basic run command
VBA