L
Legacy 242526
Guest
I have a workbook with 12 worksheets. The sheets already have a few grouped columns and rows
I want to write a macro that will group/ungroup only certain columns (ex. columns T-V and rows 5-8) but not all of the rest of the grouped columsn/rows. Lastly, I want this macro to repeat this command accross all worksheets in the workbook - hence the need for a macro to avoid going on each sheet one by one.
I have tried this code before:
<code> Sheets(s).Outline.ShowLevels rowlevels:=5, columnlevels:=5 </code>
However the above code does not allow me to select which columns/rows to group/ungroup and instead groups/ungroups everything within the sheet.
Any thoughts or suggestions ?
I want to write a macro that will group/ungroup only certain columns (ex. columns T-V and rows 5-8) but not all of the rest of the grouped columsn/rows. Lastly, I want this macro to repeat this command accross all worksheets in the workbook - hence the need for a macro to avoid going on each sheet one by one.
I have tried this code before:
<code> Sheets(s).Outline.ShowLevels rowlevels:=5, columnlevels:=5 </code>
However the above code does not allow me to select which columns/rows to group/ungroup and instead groups/ungroups everything within the sheet.
Any thoughts or suggestions ?
