Excel VBA for selecting an entire column starting from a specific cell

Question

How do I select the entire column after a specific cell?

For example, I would like to select the entire column after C24 so that includes C24, C25, ...

I have worked with the following snippet with no success:

ActiveSheet.Range("C24", ActiveSheet.Range("C24").End(xlDown)).Select

Could someone please correct my error?

Answer 1

You just need to wrap the two references within a Range:

Range(ActiveSheet.Range("C24"), ActiveSheet.Range("C24").End(xlDown)).Select

Answer 2

Here's an approach that will work even if there are cells with content below C24:

With ActiveSheet
.Range(.Range("C24"), .Range("C" & .Rows.Count)).Select
End With