Manual calculation

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?

i used the auto recording and got that

VB Code:

Application.CalculateFull

or

VB Code:

calculate

maybe this will help
maybe not:ehh:

....D'OH!!!

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

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