Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello,
To hide some columns, I'm now using this VB code; Private Sub CommandButton4_Click() Columns("F:AG").Select Selection.EntireColumn.Hidden = True CommandButton1.Activate End Sub Now I also want to hide some columns behind AH:AU. So the columns selection has to be "F:AG" and AV:ZZ, but how do I put that in the code? Can anybody tell me, it will be very simple but I just don't know! Gtrz Marc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How to keep hidden columns hidden using protection | Excel Discussion (Misc queries) |