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

JMay

Try recording a macro as you do it manually, then examine the code
auto-produced. This should get you a ways down the road...
 

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

Referring to column or row grouping using VB 1
VBA code to ungroup multiple groupings 6
Grouping will not work 1
Expand and Collapse groups 1
Command Button Macro to Expand/Collapse Grouped Columns 4
Programming Outline Expand(+) / Collapse(-) Functionality 4
Grouped columns & rows 2
Insert rows at change in cell value 3

Top