Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select | Excel Programming | |||
Convert range values to correct "hh:mm:ss" format. | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming |