Thread: Stop Automatic Calcualation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Stop Automatic Calcualation
Hi,

Application.Calculation = xlCalculationManual
'do things
Application.Calculation = xlCalculationAutomatic

Mike

"Elton Law" wrote:

Hi All,
I know VB script "Calculate" will force to run calculation on the sheet.
How to stop the automatic calculation on the sheet in VB script please ?
Thanks
Reply With QuoteReply With Quote