View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.