Hi all,

My cal mode is set to manual at start, so in code I use sendkeys
"{F9}",True, to force formula to calculate, but it failed until I press F9, I
also use "%^F9", neither work.Could you help me to fingure it out?

Clara
--
thank you so much for your help

Clara,

You should avoid SendKey as much as you can. Instead, try some of the code
below:


Application.Calculate

Dim WS As Worksheet
Set WS = ActiveSheet
WS.Calculate

Dim Rng As Range
Set Rng = Range("A1:A100")
Rng.Calculate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"clara" wrote in message
...
Hi all,

My cal mode is set to manual at start, so in code I use sendkeys
"{F9}",True, to force formula to calculate, but it failed until I press
F9, I
also use "%^F9", neither work.Could you help me to fingure it out?

Clara
--
thank you so much for your help

Clara
Could you just use a "Calculate" statement and skip the sendkeys?
Ken


On Jun 18, 3:52 pm, clara wrote:
Hi all,

My cal mode is set to manual at start, so in code I use sendkeys
"{F9}",True, to force formula to calculate, but it failed until I press F9, I
also use "%^F9", neither work.Could you help me to fingure it out?

Clara
--
thank you so much for your help