Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row grouping from one worksheet to another
Every month I get a new P&L template that can add or take away
accounts (rows) which are grouped (data-group) and formatted. What I'm trying to do is copy the formatting and grouping to a new worksheet without copying the whole worksheet If I copy the whole worksheet, the grouping comes over but destroys my formulas. Is there a way to programmatically copy the row grouping from one workheet to another? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row grouping from one worksheet to another
Perhaps something liek this:
Sub Macro() Cells.Select Selection.Copy Windows("Book1").Activate Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End Sub Always make a backup of your data before trying anything new!! Regards, Ryan--- -- RyGuy " wrote: Every month I get a new P&L template that can add or take away accounts (rows) which are grouped (data-group) and formatted. What I'm trying to do is copy the formatting and grouping to a new worksheet without copying the whole worksheet If I copy the whole worksheet, the grouping comes over but destroys my formulas. Is there a way to programmatically copy the row grouping from one workheet to another? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in Excel how do I copy & paste a grouping as one? | Charts and Charting in Excel | |||
Grouping disappears when copied to another worksheet | Excel Discussion (Misc queries) | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
Grouping & collasping in a protected worksheet | Excel Programming |