Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a problem that when I play the following macros, it hide everything, and I mean everything and not just the columns a recorded. Sub hide() ' ' hide Macro ' Macro recorded 2004/05/02 by ' ' Keyboard Shortcut: Ctrl+h ' Columns("M:O").Select Selection.EntireColumn.Hidden = True Columns("X:Z").Select Selection.EntireColumn.Hidden = True Columns("AI:AK").Select Selection.EntireColumn.Hidden = True Columns("AT:AV").Select Selection.EntireColumn.Hidden = True Columns("BE:BG").Select Selection.EntireColumn.Hidden = True Columns("BP:BR").Select Selection.EntireColumn.Hidden = True Columns("CA:CC").Select Selection.EntireColumn.Hidden = True Columns("CF:CF").Select Selection.EntireColumn.Hidden = True Columns("CM:CM").Select Selection.EntireColumn.Hidden = True Columns("CR:CR").Select Selection.EntireColumn.Hidden = True End Sub What can I do to make sure it only hides these columns and nothin more. :confused -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
Recorded Macro | New Users to Excel | |||
When i hide columns it hides whole sheet | Excel Discussion (Misc queries) | |||
Button hides unhides columns, how? | Excel Discussion (Misc queries) |