Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet that contans data in columns A to BY.
I want to hide columns from some users as they are not interested in all the data so I recorded a Macro to hide the columns that are irrelevant to those users, here is the code (after a bit of cleanup): Sheets("Internal Portfolio").Select Range("A:G,I:I,L:M,O:Q,S:S,U:BA,BC:BI,BM:BR,BT:BY" ).Select Range("BT1").Activate Selection.EntireColumn.Hidden = True Range("H4").Select When I run this macro, some of the columns which should remain visible are also getting hidden i.e. after running the macro, the visible columns are H, BB, BJ to BL and BS so it seems my Macro is ignoring some of the Range... Can anyone tell my why this happens and what I can do to fix it? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
hiding columns | Excel Discussion (Misc queries) | |||
Hiding Columns | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) |