Thread: Stopping formula computations during entering data...
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Volker Hetzer Volker Hetzer is offline
external usenet poster
  
Posts: 5
Default Stopping formula computations during entering data...
Norman Jones wrote:
Hi Volker,

Try:

Application.Calculation = xlCalculationManual

'Your code

Application.Calculation = xlCalculationAutomatic
Thanks a lot, both of you!
Volker
Reply With QuoteReply With Quote