No. You need to make you code more robust I suspect. xl2000 supports
CalculateFull. xl97 doesn't. Look at
Val(Application.Version)

--------------------------

From a post by Charles Williams:

From: Charles Williams )
Subject: Ctrl+Alt+F9
View: Complete Thread (7 articles)
Original Format
Newsgroups: microsoft.public.excel.programming
Date: 2000-11-10 01:10:45 PST

Hi Stephane,

Ctrl-Alt-F9 does a complete calculation of every formula.
F9 does a "smart recalculation" based on only recalculating the parts of the
spreadsheet that Excel thinks need to be recalculated.

In Excel 2000 [and later]:
Application.calculate ''' f9
application.calculatefull ''' ctrl-alt-f9

in Excel97
application.calculate ''' f9
SendKeys "%^{F9}", True ''' ctrl-alt-f9

HTH
Charles

-- Regards,Tom Ogilvy"Charlie Woll" wrote in
message ...
I have used the Application.CalculateFull function in VB Excel 2002.
Folks
who use this workbook with earlier versions of Excel get an error msg. Is
there a way to update their version to use this call without upgrading
their
version of excel? Is there a DLL that I can copy to their computer to
accomplish this?

charlie