Select all cells in a column , even when blank...
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.
|