I'm trying to select all the cells in column A except for A1 which is a header. I've tried
Range("A2:A").Select
and
Columns("A2:A").Select
but get a debug error when trying either one of those.