/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 vote200 views1 answer
Set datetimepicker value to null vb
VBA
1 vote159 views1 answer
Excel vba compare 2 rows
VBA
1 vote168 views1 answer
Excel vba unload userform
VBA
0 vote181 views1 answer
Find if year is leap year vb
VBA
0 vote167 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
2 votes157 views1 answer
Date format for ms chart vb.net
VBA
0 vote175 views1 answer
Vba min
VBA
0 vote172 views1 answer
Arq linux
VBA
0 vote166 views1 answer
Loop through each cell in dgv vbnet
VBA
-1 vote170 views1 answer
How to correct a number to 2 decimal places in vba
VBA