Reply to thread

Message: [QUOTE="Dave Peterson, post: 6311959"] 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 [/QUOTE]