How to group rows using VBA

A

andrei338

I am trying to group several rows in Excel using VBA. The following
command seems to work if I want to group rows 6 thru 10:

ActiveSheet.Range("6:10").Group

How do I collapse this group using VBA so that the workbook doesn't
show the rows in the group (equivalent to clicking on the little
"minus" button)? There must be a property that can be accessed, but I
haven't found it...

Thanks,

Andre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and Collapse groups 1
Use VBA to find, Group, Ungroup rows 2
Excel 2007 ang "Group row" option 1
What equation that i need to use to group in vba 3
vba code to filter the data like a group with group header 5
How to group rows? 4
Limits in SQL query 3
Range.Group Method - group rows, not columns 1

Top