Thread: "%^{F9}" doesn't cause calcaulation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default "%^{F9}" doesn't cause calcaulation
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
Reply With QuoteReply With Quote