Excel vba last 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

1 vote327 views1 answer
Add a index column power bi
VBA
0 vote359 views1 answer
Style percent not found vba
VBA
2 votes366 views2 answers
Excel vba if sunday or staurday
VBA
0 vote344 views1 answer
Enable macros on opening workbook vba
VBA
1 vote328 views1 answer
Excel vba autofit
VBA
0 vote327 views1 answer
Vb check if row has column
VBA
5 votes321 views1 answer
Vba array worksheet.index
VBA
0 vote339 views1 answer
Excel text to columns line break
VBA
0 vote346 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote315 views1 answer
Vba copy paste value only
VBA