-
How do I use createsummary?
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules