Try playing with this just a bit:

ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=1

for your example, ColumnLevels:=1 will hide column C and display the +, and
if you follow it later with same statement with ColumnLevels:=2, then you are
back to column C visible plus the line and the - symbol.

Don't forget that their is also an .Ungroup method to go along with the
..Group method.

Hope this helps some.


"Michiel via OfficeKB.com" wrote:

Hi,

I can Group a column e.g. via:

columns(3).columns.group

When I do this the result is a line on top of col C and D with a little box I
can click on to hide column C. Leaving just a box with a little PLUS above
column D.

How can I appy that directly via VBA code?

Thanks!

--
Message posted via http://www.officekb.com