B brettvba MrExcel MVP Joined Feb 18, 2002 Messages 1,030 Sep 11, 2002 #1 Does anyone know how to make the macro wait till the calculation is finished? Brett
DonkeyOte MrExcel MVP Joined Sep 6, 2002 Messages 9,123 Sep 11, 2002 #2 there is something called "wait" I think but can't remember the exact code...anyone?
Andrew Poulsom MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Sep 12, 2002 #3 As far as I know the Calculate method pauses Excel until calculation is complete. Is calculation set to automatic? If so: Code: Application.Calculation = xlManual ' *** Your code goes here *** Application.Calculation = xlAutomatic
As far as I know the Calculate method pauses Excel until calculation is complete. Is calculation set to automatic? If so: Code: Application.Calculation = xlManual ' *** Your code goes here *** Application.Calculation = xlAutomatic
B brettvba MrExcel MVP Joined Feb 18, 2002 Messages 1,030 Sep 12, 2002 #4 Thanks Guys, I was actually wanting to make sure all the calculations on the sheet were done before I .value the formulas, I have tried application.calulate that seems to work but takes a very long time, Brett
Thanks Guys, I was actually wanting to make sure all the calculations on the sheet were done before I .value the formulas, I have tried application.calulate that seems to work but takes a very long time, Brett