Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collapsing/expanding grouped areas on multiple pages
I have a workbook with many similarly formatted pages, all will certain
grouped rows and columns. Is there any way to expand them on all pages or collapse them on all pages simply, or do I have to go to every page?? Thanks for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collapsing/expanding grouped areas on multiple pages
Are you comfortable working with VBA?
Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets 'If InStr(1, sh.Name, "Sheet1") Then...use this if you have certain sheets that you want to ignore sh.Select False Else 'Do what you want to do right here!! End If Next sh End Sub Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Maxsteel" wrote: I have a workbook with many similarly formatted pages, all will certain grouped rows and columns. Is there any way to expand them on all pages or collapse them on all pages simply, or do I have to go to every page?? Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding / Collapsing rows | Excel Discussion (Misc queries) | |||
Expanding and Collapsing | Excel Discussion (Misc queries) | |||
shortcut for expanding/collapsing groups | Excel Discussion (Misc queries) | |||
Expanding and collapsing rows | Excel Discussion (Misc queries) | |||
Expanding/Collapsing Rows? | Excel Worksheet Functions |