I've never seen DoEvents put the application in manual calculation mode.

In any event, you might be better off putting Excel in manual calculation
mode at the start of the macro, and calling Application.Calculate just
before you want to pick up any results. Don't forget to turn it back to
automatic at the end of the routine.

Tim



"xl@lf" wrote in message
...
I tried the Doevents and it appeared to put the spreadsheet in manual
calculation mode. The macro processed at a blazing speed and all the
output data was identical. When the macro was finished I pressed F9
and it updated all the values. Since I'm constantly updating values
manual calculations won't work for me in this macro. Thanks Tim.