Excel does not calculates consistent based on the number of open
worksheets.

In a nutshell:
Two cells on a worksheet are input into a macro. Macro calculates as
soon as only one cell is changed (using the unchanged value in the
second cell). Second cell in the workbook changes after the macro
finishes. End of calc.
I get the correct value after pressing F9.

Win 2000 Pro, 512 MB, Excel 2003 SP2

There is of course more, but this happens after a certain amount of
worksheets are open.
Anybody out there willing to discuss this with me? I am at my wits
end.

Juergen


--
JuergenL
------------------------------------------------------------------------
JuergenL's Profile: http://www.excelforum.com/member.php...o&userid=21816
View this thread: http://www.excelforum.com/showthread...hreadid=529313

hi Juergen,

Not sure I understand what you are doing or what is going wrong:

You have a Sub which is called when one cell is changed (How is it called?)
The Sub runs and changes another cell (I assume inserts a value into the
cell).

Something does not work (what does not work?) until you press F9

Do you have a circular process?

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"JuergenL" wrote in
message ...

Excel does not calculates consistent based on the number of open
worksheets.

In a nutshell:
Two cells on a worksheet are input into a macro. Macro calculates as
soon as only one cell is changed (using the unchanged value in the
second cell). Second cell in the workbook changes after the macro
finishes. End of calc.
I get the correct value after pressing F9.

Win 2000 Pro, 512 MB, Excel 2003 SP2

There is of course more, but this happens after a certain amount of
worksheets are open.
Anybody out there willing to discuss this with me? I am at my wits
end.

Juergen


--
JuergenL
------------------------------------------------------------------------
JuergenL's Profile:
http://www.excelforum.com/member.php...o&userid=21816
View this thread: http://www.excelforum.com/showthread...hreadid=529313