| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to group rows using VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to group rows using VBA
depending on your intent use:
~ .Outline.ShowLevels " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group rows (or hide rows) like in MS Project | Excel Worksheet Functions | |||
| group rows between blank rows | Excel Discussion (Misc queries) | |||
| group rows | Excel Discussion (Misc queries) | |||
| group rows | Excel Programming | |||
| group of rows and element | Excel Programming | |||
Linear Mode
