Hello, has anyone come across this problem before..

I have some code which looks in each cell and hides the row if it meets
a certain criteria. If i run the code it works instantaneously but after
printing the worksheet (or print previewing it) the code takes ages.

Is there an obvious reason for this?

Thanks

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=513682

Hi John,

It is likely that the hiding of rows is causing Excel repeatedly to
recalculate the position of pagebreaks, which can be very slow.

Try wapping your code something like:

On Error GoTo XIT

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

With ActiveWindow
ViewMode = .View
.View = xlNormalView
End With

SH.DisplayPageBreaks = False


'YOUR CODE '<<====


XIT:
With Application
.Calculation = CalcMode
.ScreenUpdating = True
End With

ActiveWindow.View = ViewMode

End Sub


---
Regards,
Norman



"johncassell"
wrote in message
...

Hello, has anyone come across this problem before..

I have some code which looks in each cell and hides the row if it meets
a certain criteria. If i run the code it works instantaneously but after
printing the worksheet (or print previewing it) the code takes ages.

Is there an obvious reason for this?

Thanks

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile:
http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=513682

Cheers Norman, I wrapped my code but it made my code not work at all!

I simply cut sh.DisplayPageBreaks = False from your code and put it at
the top of mine which worked perfectly.

Thanks very much.

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=513682