Macro te expand/collapse range

[graiggoriz]

Hello,

I have a range tha I called "DETAIL" I need to expand/collapse groups with same macro button.

CAn you please help me? I found some info on expanding rows but not a range.

Thanks ,
Graig

[nathansav]

You could do something like this, i am not in excel so not tested

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[graiggoriz]

Thanks but I would need only one macro.

[nathansav]

Combine the 2 with an if statement and another argument to say which way then :o)

[graiggoriz]

I really have no clue how to do that though.. Can you help?

In fact if the range is not easy to expand and collapse, I could use the rows 126:442 instead of range..

Would appreciate your help on that.

Thanks,
Graig