/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 vote185 views1 answer
Change form background image vb
VBA
0 vote186 views1 answer
Putting marquee in vb.net
VBA
0 vote184 views1 answer
Vbnet line chart showing extra space
VBA
0 vote175 views1 answer
Remove last 8 characters from string vb
VBA
0 vote190 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote170 views1 answer
Excel vba address not absolute
VBA
0 vote185 views1 answer
Vba horizontalalignment
VBA
0 vote178 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote187 views1 answer
Vba exit while
VBA
0 vote179 views1 answer
How to mount floppy disks in vb.net
VBA