Hi Tom,

Could you tell me the difference between the two method? They all works well.

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Application.Calculation isn't equivalent to the sendkeys you show.

Try using Application.CalculationFull

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi,

it is in Excel 2000.
--
thank you so much for your help


"JLatham" wrote:

How about using the .Calculate method? Is this code in Excel or another
application?


"clara" wrote:

Hi all,


I use Application.SendKeys "%^{F9}", True to cause calculation, but it
failed. My Excel version 2000.

Clara

--
thank you so much for your help