Forum Discussion
Excel
Sep 07, 2022Iron Contributor
Question related to VBA code.
Hello Everyone, I want something different in VBA code. Like if I have data in A Column from A1 to A13 and in B Column, the data is from B1 to B4 and B6 to B8 If I will apply VBA - Ra...
HansVogelaar
Sep 07, 2022MVP
Sub SelectToLastRow()
Dim LastRow As Long
LastRow = Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Range(ActiveCell, Cells(LastRow, ActiveCell.Column)).Select
End Sub