Manual calculation

[jeffcravener]

I have an automated report that creates multiple sheets with many formulas on it.

Sometimes when you re-create the report (when changes occur) the formulas will not calculate.

I figured out how to manually calculate every formula in the workbook:
Press CTRL+SHIFT+ALT+F9

How do I do the same thing in code? So I can have it execute after it runs?

[writelearner]

i used the auto recording and got that

Application.CalculateFull

or

calculate

maybe this will help
maybe not

[jeffcravener]

....D'OH!!!

I always forget about the recording feature....fricka fracka...

Thanks!!! I'll give it a go...