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