Hi,

I have quite a large workbook to calc. When I hit Ctrl+Alt+F9, it seems to be fine. However, inside the marco, when it does Application.calculate, sometimes, the total give a "#VALUE".
Do you know why this happens? Is there a way to prevent this from happening? or at least reduce the frequecy of getting a "#VALUE" after calc?

Thanks!!!!!

;)

Try have a look at this:
    http://www.decisionmodels.com/calcsecretsj.htm

Maybe your problem is described there.