View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim@Tech Jim@Tech is offline
external usenet poster
 
Posts: 11
Default Another query about hiding columns with Macros

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!