Snedkeys "{F9}", true does not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top