/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 vote187 views1 answer
Excel vba named range exists
VBA
7 votes188 views1 answer
Excerl vba array to range
VBA
0 vote164 views1 answer
Vba string
VBA
2 votes212 views1 answer
Vba round number
VBA
2 votes168 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
3 votes185 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote177 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote169 views1 answer
Not allow form to be resized
VBA
3 votes158 views1 answer
Vba not equal
VBA
0 vote186 views1 answer
Vbscript Trim
VBA