I have an inputbox which captures a user selected range.

From this range, i am able to get the column number via range.column

is there a easy way to reference this column in vba?

currently, i'm using range(cell(1,column#),cell(65000,column#)) which seems
like a complicated way to select the column

i'm hoping there's something like column(column#).select