Closing Grouped columns

ryancey

New Member
Joined
Oct 11, 2005
Messages
46
Does anyone know how to close grouped columns in VBA.
I have a macro that goes through about 50 tabs and groups the columns but leaves the group open. I'd love to know the syntax to close the group that I just created on each tab. Thanks.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

ryancey

New Member
Joined
Oct 11, 2005
Messages
46
I'm not sure what eg means. Here's what I'm doing.
I'm using Selection.Columns.Group to group a range of selected column. That leaves me with the little "-" minus sign at the top of the worksheet. I'd like to put a line below the Selection.Columns.Group line to close the group and leave me with the little "+" plus sign.
Thanks.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Did you try what I suggested?

Code:
Sub Test()
    Columns("D:F").Select
    Selection.Columns.Group
    Worksheets("Sheet1").Outline.ShowLevels columnLevels:=1
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,029
Members
410,647
Latest member
bernardazar
Top