Double check 'where' is the 'Active' column:
If it is respect to the LastCell, the code returns the 2nd to the last column
in the data set.
If the intent is upon an active cell in column 'D', & you are looking to
select column 'C' in the code, we need to make a slight adjustment to grab the
active column 'before' moving to the 'LastCell':
Sub SelectColumn( )
Dim iRow as Integer
Dim iCol as Integer
iCol = ActiveCell.Column
ActiveCell.SpecialC ells(xlLastCell) .Select
iRow = ActiveCell.Row
Range(Cells( 1,iCol - 1),Cells(iRow, iCol - 1)).Select
End Sub