Hi all,

Lately I've been working with a file with a lot of formulas and I have experienced yet another problem:

application.calculate does not work as intended. In my opinion the number of cells/formulas is so big, that the calculation doesn't affect all the cells before the code goes to the next line. I found this problem to be quite known while googling. I found many solutions which in my case sadly won't work:

Application.CalculateFull(+rebuild)
Application.CalculationInterruptKey = xlNoKey
Sendkeys
and some more.

Does anyone know a failproof way to be sure that the calculation goes all the way? In my case the macro copies #Value! and does some action with it since the calculation does not occur fully:/ I know that its a calculation problem since when I stop the code at the given line and press F9 within the sheet, the cells update.

Thanks