Pausing procedure until worksheet finishes calculating

[Guest]

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.

 

[Don Guillett]

application.enableevents=false
your code
reset to true