Go To Last cell in column of active cell. Column has blank cells in between first and last used row

[mdd16]

Hello,

Can some please help do a VBA code for

Go To Last cell in column of active cell. Column has blank cells in between first and last used row.

I want to select the last cell and not select entire block of Used Cells.

And I want to scroll down to the cell

Thanks for help.

 

[Alex Blakenburg]

How about:

Sub SelectLastCellInCol()

    Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select

End Sub

 

[mdd16]

Thanks so much.. simple and effective.

 

[Alex Blakenburg]

You're welcome. Glad I could help.