Pausing procedure until worksheet finishes calculating
 

I am writing a macro for a workbook that has
a "Calculation" worksheet. There is a Loop procedure that
passes numbers through this "Calculation" worksheet and
each time, the output is copied to a different worksheet.
It looks like the copy part is happening before
the "Calculation" worksheet can finish calculating. Is
there a way to pause the procedure until the worksheet is
done calculating?

Thanks.

Pausing procedure until worksheet finishes calculating
 

application.enableevents=false
your code
reset to true

--
Don Guillett
SalesAid Software

wrote in message
...
I am writing a macro for a workbook that has
a "Calculation" worksheet. There is a Loop procedure that
passes numbers through this "Calculation" worksheet and
each time, the output is copied to a different worksheet.
It looks like the copy part is happening before
the "Calculation" worksheet can finish calculating. Is
there a way to pause the procedure until the worksheet is
done calculating?

Thanks.