/VBA/Excel vba first and last row and column in range

Excel vba first and last row and 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 vote155 views1 answer
Excel vba DisplayAlerts
VBA
0 vote149 views1 answer
Vbscript remove spaces from string
VBA
0 vote105 views10 answers
Vba excel create event log
VBA
0 vote155 views1 answer
Vba remove last vbcrlf
VBA
0 vote143 views1 answer
How to use VBA to add new record in MS Access?
VBA
22 votes276 views1 answer
Xlvba check for folder
VBA
0 vote153 views1 answer
Discern between file and folder given path vb.net
VBA
7 votes155 views1 answer
Vba array declaration
VBA
0 vote159 views1 answer
Vba paste values
VBA
-1 vote143 views1 answer
For i in range vba
VBA