problems with using application.calculate
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?