Grouping function in VBA Excel
 

Hi everyone. Could You give me a tip?

In Excel menu-Data-Groups And Conspects-Group option is located. How can
I achieve the same effect from VBA code?

Greetings. P.

Grouping function in VBA Excel
 

I would think it is Range.Rows.Group (or columns)

Mike F
"bobens_83" wrote in message
...
Hi everyone. Could You give me a tip?

In Excel menu-Data-Groups And Conspects-Group option is located. How
can
I achieve the same effect from VBA code?

Greetings. P.

Grouping function in VBA Excel
 

Brilliant! But I have one more thing. How to set that grouped range rolled up
after grouping?