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

Jim@Tech wrote:

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!

"Dave Peterson" wrote:

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.

Jim@Tech wrote:

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!

--

Dave Peterson


--

Dave Peterson