| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Grouping function in VBA Excel
Brilliant! But I have one more thing. How to set that grouped range rolled up
after grouping? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping Function on protected sheet | Excel Discussion (Misc queries) | |||
| Need a Function for Grouping | New Users to Excel | |||
| Locking cells but keeping Grouping Function available | Excel Worksheet Functions | |||
| Function for grouping range of data | Excel Worksheet Functions | |||
| Am I able to protect my work sheet and keep my grouping function? | Excel Worksheet Functions | |||
Linear Mode
