Problem with speed marco excel 2003 and excel 2007.

[Petr]

Hello,

I have question about problem with speed marco. I made marco in excel 2003.
If start the marco in excel 2003 they speed is ok around 1 minut but start
the same marco in excel 2007 speed is very slow 5 - 6 minut.

Can you help me ? I don't know when is problem.

Thank you

Petr

 

[Dave Peterson]

Without knowing any details about your macro...

Saved from a previous post:

If you turn off the page break lines
tools|options|view tab|uncheck page breaks (in xl2003)

Does the code work faster?

When you're hiding rows/columns, excel wants to figure out where to draw those
lines each time you change the layout.

Turning of calculation and making sure you're in Normal view will help, too.

Option Explicit
Sub testme()

Dim CalcMode As Long
Dim ViewMode As Long

With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With
ViewMode = ActiveWindow.View
ActiveWindow.View = xlNormalView

'your real code here

'put things back to what they were
With Application
.ScreenUpdating = True
.Calculation = CalcMode
End With
ActiveWindow.View = ViewMode

End Sub