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