Excel VBA to select an entire column starting from a specific cell

Question

How to select the entire column after a specific cell?

For example, I would like to highlight the entire column after C24 to include C24, C25, ...

I worked with the following snippet without success:

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

Can someone fix my mistake?

Answer 1

You just need to wrap two links within Range :

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

Answer 2

Here is 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 

Answer 3

I don’t know if you need a formula for it or if any method will work, but if you select the cell in which you want to run it and hold Ctrl + shift + down arrow, it will select this cell and everything below it,