PDA

View Full Version : How do I use createsummary?



compariniaa
06-23-2006, 11:08 AM
Browsing through the object browser, I came across "createsummary" when I looked at excel's help, it gave me a less than helpful description, with some sample code:

Worksheets("Sheet1").Scenarios.CreateSummary _
ResultCells:=Worksheets("Sheet1").Range("C4:C9")

so I started a new sub and pasted that in there, hoping it would work so I could fiddle with it. not surprisingly, my blank workbook didn't cut it, and I got an error (Run-time error '1004': CreateSummary method of Scenarios class failed). what would I have to do to get this code to work so I could play with it?

Note: I'm not familiar with scenarios either

Cyberdude
06-24-2006, 12:51 PM
I know about as much about this as you do, but I suspect that "scenarios" has to do with Pivot Tables, goal seeking, and the like. I doubt if it's what you want.