chris jamieson presented the following explanation :
I too have been experiencing this problem and am keen to try the Sub
SpeedUpMacro you've included, but I have probably 30 vba codes. Would I need
to add this Sub SpeedUpMacro to all of those 30 or just one, and if just one,
how do I know which one?

Chris

Not sure where this SpeedUpMacro code came from but looks like
something I posted here some time ago in this reusable sub:

Public Sub EnableFastCode(Optional SetFast As Boolean = True)
With Application
If SetFast Then
.ScreenUpdating = False
.Calculation = xlCalculationManual
Else
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.Calculate '//update changes
End If
End With
End Sub

To use it in any procedu

Sub SomeSub()
'dim your vars and do other stuff before running main process

'before you run main process, turn it on
EnableFastCode
'code to do lengthy stuff or lots of recalcs goes here

'at end of main process, turn it off and recalc
EnableFastCode False

'cleanup code goes here
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc