VBA: Collapse Column Groupings

C

CM4@FL

I have a spreasheet with Columns H-AB, BD-BF, and BJ-CD grouped. Therefore I
have 1 level of column grouping. What is the VBA code to collapse and expand
these groupings?

Thanks in advance
 
J

joel

I think you would want to keep the 1st columns H, BD, and BJ and hid th
other columns or unhide these columns

columns("I:AB").Hide
columns("BE:BF").Hide
columns("BK:CD").Hide

columns("I:AB").UnHide
columns("BE:BF").UnHide
columns("BK:CD").UnHid
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Create form with checkbox les that expand and collapse sections of the form? 0
expanding or collapsing groupings in protected worksheets 5
Sorting within Groupings 0
Subtotal error to expand Outline Levels 1
Referring to column or row grouping using VB 1
Grouping will not work 1
Permutation/Combination/Pairs order unimportant. 2

Top