Hide show grouping?

[notuserfriendly]

Hi I'm trying to find out how to hide and show
a grouping (columns). Trying to use outline but doesn't seem to work.

ActiveSheet.Outline.ShowLevels 2
ActiveSheet.ShowDetail = False

Anybody?

 

[GlennUK]

I've had problems with Outlining in VBA before, and ended up doing this:

ExecuteExcel4Macro "SHOW.DETAIL(2,77,TRUE)"

where arg1 is the row, and arg2 is the column, and arg3 is show/hide ( I think ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.