column of a input box selected range
Hi Dennis,
Is the following example what you want?
Dim colNumber As Long
colNumber = 8
Columns(colNumber).Select
--
Regards,
OssieMac
"Dennis Chou" wrote:
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
|