Thank you, the your responses solved my problem
charlie

"Charles Williams" wrote in message
...
calculatefull is available in Excel2000 and later. prior to that you have
to
use sendkeys to simulate Ctr-alt-F9

if val(application.version)<9 then

Application.SendKeys "%^{F9}"
DoEvents

else
application.calculatefull
endif

"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