Collapsing/expanding grouped areas on multiple pages

M

Maxsteel

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!
 
R

ryguy7272

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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top