Convert from ColumnNumber to Range(" ")
How about this way... it asks the user which column letter(s), NOT which
column number, he/she wants to hide up to starting at Column C...
WhichCol = InputBox("What column letter(s) do you want to hide up to?")
Columns("C:" & WhichCol).Hidden = True
Note there is no error checking in this code to make sure the column is at
least Column C and no larger than the letter designation of the user's
version of Excel... you should incorporate some in your actual code.
--
Rick (MVP - Excel)
"Brian B" wrote in message
...
Hello,
I'm having trouble with what I would think is a very simple issue. I
would
like to hide a number of columns but I would like it to be subject to user
input.
Here's the very simple code that cuts out the user input:
Columns("C:AH").Select
Selection.EntireColumn.Hidden = True
But I want column "AH" to be user selectable. The User would input the
number '36' (the number of columns over from the left "AH" is) and that's
how
C:AH would be hidden.
How do I convert '36' into a Column Range unit? I've been messing around
with As Range and haven't been real lucky.
Thanks in advance for any assistance,
Brian
|