p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   problems with using application.calculate (http://p2p.wrox.com/showthread.php?t=12862)

applejuice May 11th, 2004 09:13 AM

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

;)


Birger May 12th, 2004 12:09 PM

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

Maybe your problem is described there.


All times are GMT -4. The time now is 09:40 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.