Excel help

[Dr Zoidberg]

Im putting together a spreadsheet that has a lot of columns that are not all needed in view at the same time,

I have seen a spreadsheet before that had black tabs placed along the column and row edges that would hide/unhide selections, but no matter where i look or how i search on-line i can not find our how this is done,
Any one know what i am talking about or how to do it?

Failing that i have added a selection of buttons and written code to hide/unhide sections,
The only problem with this is the code is written to work on column referances, A B C D etc etc
So in a few weeks time if i need to add a new column in the middle of the sheet i will need to edit a lot f the code lines to reflect the fact everythig will move along a column,
Is there any way to give a group of columns a name and then code that name to hide instead of A B C etc ?

Would prefer to put the 'tabs' in place and do it that way if possible.

thanks

 

[Participant]

First part - I think you need data, subtotals.

Second part, go insert, name, define range, and define the ABCD etc as a dynamic named range. Then you just need to insert etc and the range will adjust to suit.

 

[Dr Zoidberg]

First part - I think you need data, subtotals.

Second part, go insert, name, define range, and define the ABCD etc as a dynamic named range. Then you just need to insert etc and the range will adjust to suit.

Thanks

At te moment the code for the butons is some thing along the lines of

worksheet("1").columns("A").hidden = True

etc etc

How would i change that to work with a range name ?

 

[Participant]

Try

Range("[name of range]").Select