/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 vote167 views1 answer
Vbnet click on dgv cells
VBA
0 vote153 views1 answer
Vb net dgv doesn't keep currency format
VBA
5 votes170 views1 answer
Xlvba double quotes in string literal
VBA
3 votes206 views2 answers
Excel "vba" match last value
VBA
1 vote169 views1 answer
How to remove zeros in excel
VBA
0 vote161 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote158 views1 answer
Search in richtextbox vb.net
VBA
0 vote153 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote148 views1 answer
Excel vba formatconditions positive
VBA
0 vote173 views1 answer
Vba count all row
VBA