Select Entire Column Minus Header Row in Excel Macro

Question

How would I access a range that corresponds to an entire column starting at row 2 (there is a header row)? The end of the selection should be the last non-empty cell in the column.

Answer 1

How to select cells/ranges by using Visual Basic procedures in Excel

see # 19 (How to Select an Entire Range of Contiguous Cells in a Column)

Answer 2

Hi Dave you can use the excel key board short cuts...

Try this ....

Press ctrl+Home.

this would take you to the cell A1 ( if you have not used the freeze pane)

come 1 cell down and then use "CTRL+SHIFT+DOWN arrow button to select till the last entered row"

if you have to select the column value use the right arrow button instead of the down arrow button.

Answer 3

Try this:

Range(Range("A2"),Range("A2").End(xldown)).Select

or this:

Range(Range(Cells(2, 1), Cells(2, 1)), Range(Cells(65535, 1), Cells(65535, 1)).End(xlUp)).Select