XL2000: Creating scenario crashes Excel

In a workbook originally designed in XL2007 but ported to XL2000:

The workbook contains a range of external text data (a Quicken export) that is updated on open. The data will then be used to populate scenarios. Because the line items in the data may change the code below steps through the line items to create range names and assign their values. At the end an existing scenario is deleted and recreated. edit: after the code runs Excel crashes when clicking on Tools, Scenarios.

I've narrowed the source of the crash down to the line that creates the scenario. (Excel also crashes if I use ChangeScenario rather than delete and create.)

Is there a work-around? Or have I misused the Scenarios object?

Thanks.

George

Please Login or Register  to view this content.

In an experiment I used Scenarios.Add (with range names and values created by the above code) to create a scenario in a new, otherwise unused worksheet. I was able to get to the scenario (via Tools, Scenarios...) without crashing. So clearly there is something about the Consolidation sheet that does not like having a scenario created. It's not the code, it's the sheet.

Edit: So I tried a copy & paste values of the sheet to a new workbook. Ran the above code (less the Scenario.Delete) and it also crashes on Tools, Scenarios.

Ugh!

g