Question related to VBA code.

Question

Hello Everyone,&nbsp;&nbsp;&nbsp;I want something different in VBA code.&nbsp;&nbsp;Like if I have data in A Column from A1 to A13 andin B Column, the data is from B1 to B4 and B6 to B8&nbsp;If I will apply VBA - Range(ActiveCell, ActiveCell.End(xlDown)).Select, it will only select data from B1 to B4.&nbsp;But I want to select data from B1 (ActiveCell) to B13 (Last used row in that worksheet)&nbsp;It can be done by ASAP Utilities.ASAP &gt; Select &gt; 9.Extend Selection to the last used row&nbsp;Please help..??&nbsp;Here is a attached file...&nbsp;

hansvogelaar · Answer

Excel&nbsp;
Sub SelectToLastRow()
    Dim LastRow As Long
    LastRow = Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    Range(ActiveCell, Cells(LastRow, ActiveCell.Column)).Select
End Sub

harun24hr · Answer

Excel&nbsp;Try below simple macro.Sub SelectTillLast()
Dim lr As Long
    lr = Cells(Rows.Count, "A").End(xlUp).Row
    Range("B1:B" &amp; lr).Select
End Sub

Forum Discussion

Question related to VBA code.

Share