Posted to microsoft.public.excel.misc

CM4@FL[_2_] CM4@FL[_2_] is offline

external usenet poster

Posts: 12

VBA: Collapse Column Groupings

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Group of column can't be expanded or collapse after I set a protec	ToMMie	Excel Discussion (Misc queries)	1	September 11th 08 07:06 PM
Auto Filter - how to collapse "non-blank" cells in a column?	marla	Excel Discussion (Misc queries)	2	August 24th 08 10:03 PM
Groupings in a scattergraph	Bee	Charts and Charting in Excel	2	August 14th 07 03:06 AM
Outlining - collapse rows based on repeated column value	Beebe	Excel Discussion (Misc queries)	4	June 15th 06 12:39 AM
Groupings within PivotTables	Fred	Excel Worksheet Functions	1	October 18th 05 11:45 PM

All times are GMT +1. The time now is 08:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us