Another query about hiding columns with Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Thanks for the response Pranav, unfortunately it doesn't really address the
probelm...

The columns that should remain visible are columns H, J, K, N, R, T, BB, BJ,
BK, BL and BS. These are all excluded from the Range statement so I can't see
why the macro is hiding columns J,K,N,R and T...
 
I bet you're using merged cells.

Merged cells behave slightly differently in each version of excel--but they
don't play nice in all versions (in my opinion).

If you don't have merged cells, you may want to show all the columns, then do
the hiding.
 
Genius!
Why didn't I think of that...? I really dislike merged cells, they seem to
cause so much more trouble than they are worth! Trouble is this is a shared
workbook and one of my colleagues was trying to make it look nice :/

Many thanks Dave, Excel rocks again!
 
There comes a time when everyone has to make that decision--do you want a nice
looking worksheet, or do you want something that functions?

I think most responders have come down on the functionality side.

Welcome to the group! <vbg>
 
Back
Top