Snedkeys "{F9}", true does not work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clara - 18 Jun 2007 20:52 GMT

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

Signature

thank you so much for your help

Reply to this Message

Chip Pearson - 18 Jun 2007 20:59 GMT

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

Signature

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

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Clara

Reply to this Message

krcowen@aol.com - 18 Jun 2007 22:27 GMT

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

> Hi all,
>
[quoted text clipped - 5 lines]
> --
> thank you so much for your help

Reply to this Message