View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin H. Stecyk[_2_] Kevin H. Stecyk[_2_] is offline
external usenet poster
 
Posts: 43
Default Calculation Mode

Norman Jones...
Hi Kevin

Sub Tester()
Dim CalcMode As Long

With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
End With

',,,,,,,,,,,,,,Your Code

With Application
.Calculation = CalcMode
End With

End Sub

---
Regards,
Norman


Norman,

That is exactly what I would looking for. Thank you very much.

Best regards,
Kevin