Hi All




I use this code to select all of the cells from the active one down to the bottom of the column :


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


However , if the last few cells of the particular column happen to be blank , it doesn't select them.


Can someone help with a way to modify the code so that all cells in the column are selected to the bottom , irrespective of being blank or not? It needs somehow to find bottom-most cell of the whole sheet and then select to there , rather than solely in the specific column in question.



Grateful for any advice.