It is turned off. I run this method at the start of every entry point:

Public Sub ScreenUpdating(Optional bEnable As Boolean = True)

Application.ScreenUpdating = bEnable
Application.Calculation = IIf(bEnable, xlCalculationAutomatic,
xlCalculationManual)
Application.Interactive = bEnable
Application.EnableEvents = bEnable
ThisWorkbook.Running = Not bEnable

End Sub 'ScreenUpdating


--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003



"Peter T" wrote:

Just curiosity, is calculation dis/enabled during the process

Regards,
Peter T

"J Streger" wrote in message
...
It seems that every time I try to merge cells via VBA, it takes forever.
Code
that ran in 1 second in 2003 is taking over 10 seconds in 2007, and Excel
is
stating it is Not Responsive so even the status bar is not updating. I
tried
to pull all of the merging out of my loop and do it in one line, thinking
that this would be faster, but alas it seems the merging time is
proportonal
to the amount of sections I'm merging. Anyone else have this issue and
know
how to fix?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003