VBA - Getting the statuts of the groups, and expandind/collapsing the desired ones

Hello,

I get a problem to make my macro, I explain my problem :

- I have several group of columns (not a fixed number)
- I have a macro that resize all the column size and when it does resize them, it expands all the groups

What I would like to do is getting the collapsed/expanded groups still collapsed/expanded after my macro.
My idea to do that is before applying my macro, I get the number and the status of each group that I record in an array, I apply my macro and then I restore the statuts of each group

Do you know how I could do that? Do you have another idea for doing it?

Thank's

Tibibs

up