Expand/Collaps Group Based on Selected Cell

[FallingDown]

Hi everyone

Is it possible to expand/collaps grouped columns with VBA?
I know it's possible to expand/collap the entire "level". But I am interested in single group.

i.e.

Group cols. are A to E and F to P

When the user selects column A, group "A to E" should automatially expand.
If he then selects a cell in col. F, "A to E" should collaps and "F to P" should expand.

Thanks
FD

[Marc L]

Hi,

it's possible : activate Macro Recorder and do it manually : you'll get a free code !

[FallingDown]

Hi Marc

I treid that before posting here!
I would not have opened the thraed otherwise ;-)
It does not record anything

It only records when you collaps/expand the entire level (i.e. level 2)