Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to find, Group, Ungroup rows
Hi, I have a worksheet with nested groups of rows, e.g., rows 1 to 10 are
grouped and within that group rows 5 to 10 are grouped. I'm trying to write code that will find the number of groups on the page and which rows they apply to so I can automate the insertion of new groups of rows between others. All I can find in Excel VBA Help is the basic syntax for the Group/Ungroup command. Can anyone suggest a resource for more advanced use/control of these? Any help is deeply appreciated, Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Group and Ungroup | Excel Discussion (Misc queries) | |||
group&ungroup | Charts and Charting in Excel | |||
On protected Excel sheet users be able to group/ungroup rows/colum | Excel Worksheet Functions | |||
Help with Group/Ungroup | Excel Discussion (Misc queries) | |||
how do you group and ungroup rows or columns in new Excel? | Excel Worksheet Functions |