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

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

Try,

Application.Calculate

Mike

"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

Sub kick_it()
Application.SendKeys "{F9}"
DoEvents
End Sub

will cause a single calculation, but will leave the mode in Manual
--
Gary''s Student - gsnu200731


"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

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

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

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

Hi Gary's Student,

When I run my macro which contains your method, F5 press became F9 press
that means a break point is set at the line I press F5 instead of running the
macro.
Could you tell me the reason. The same thing happened to me before.

Clara
--
thank you so much for your help


"Gary''s Student" wrote:

Sub kick_it()
Application.SendKeys "{F9}"
DoEvents
End Sub

will cause a single calculation, but will leave the mode in Manual
--
Gary''s Student - gsnu200731


"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

Keys are sent to the active application, whichever that is.
So you cannot run such code from the VBA IDE and consequently cannot debug
it.
Run from the click a button will work.

NickHK

"clara" ...
Hi Gary's Student,

When I run my macro which contains your method, F5 press became F9 press
that means a break point is set at the line I press F5 instead of running
the
macro.
Could you tell me the reason. The same thing happened to me before.

Clara
--
thank you so much for your help


"Gary''s Student" wrote:

Sub kick_it()
Application.SendKeys "{F9}"
DoEvents
End Sub

will cause a single calculation, but will leave the mode in Manual
--
Gary''s Student - gsnu200731


"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

CalculateFull does a more complete recalculation of the workbook. It doesn't
just recalculate the cells which excel considers in need of calculation -
this is what calculate does. Since you didn't write the macro, the original
author appeared to want to do a CalculateFull (which did not exist as a macro
command in xl97 and thus many used the sendkeys combination you show).

From VBA help:
CalculateFull:
Forces a full calculation of the data in all open workbooks.
CalculateFullRebuild: (added in xl2002 I believe)
For all open workbooks, forces a full calculation of the data and rebuilds
the dependencies.

-------------------------------------------
Calculate:
Calculates all open workbooks, a specific worksheet in a workbook, or a
specified range of cells on a worksheet, as shown in the following table.

When using "calculate", To calculate Follow this example
All open workbooks - Application.Calculate (or just Calculate)
A specific worksheet - Worksheets(1).Calculate
A specified range - Worksheets(1).Rows(2).Calculate
----------------------------------------


Whether the more thorough calculation is actually required or not, I can't
say.

--
Regards,
Tom Ogilvy


"clara" wrote:

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