Hi!
Are you using "application.volatile = false"?
I don't know this function
Does the status bar say "Calculate" even after you do a manual
calculation?
It takes 3 seconds to calculate as when I do an "Application.Calculate".
When this is done, the status bar indicate doesn't indicate calculate..
Sometimes, I do a F9 and even after the calculation, the results have changed
but the data is not correct. Then, if I go in the cell that make the
"=average(C2:M1000)" and edit the function, the value is changing when I
press Enter.. This happens not often but should not happens. I don't know if
there's a way to be sure all calculations are done in VBA?
Thanks a lot!
Alex
--
Alex St-Pierre


"JP" wrote:

Hi,
Are you using "application.volatile = false"?

Does the status bar say "Calculate" even after you do a manual
calculation?



On Oct 4, 2:49 pm, Alex St-Pierre
wrote:
Hi!
I have an excel file that calculate 10 000 simulations. For each simulation,
I use the Application.Calculate (takes 3 seconds) to refresh the result.
Thereafter, I copy the interesting result inside a cell and I do it for all
simulations. The problem I have is that Application.Calculate doesn't refresh
all the workbook. File= 130 mo.
Is there anything else I can write to ensure all calculations have been done?
Thank you!
Alex
--
Alex St-Pierre