Does your code insert/delete rows or columns?

If yes, then having that dotted line indicating where the page breaks should go
can slow down your macro.

Something like:
ActiveSheet.DisplayPageBreaks = False
at the top of the code could speed things up.



modjoe23 wrote:
>
> I'm not sure, but I may have panicked. I was just thinking of how
> possible it is that excel would set screenupdating to true in debug
> mode so that people can look at the sheets during that time. I'm
> definitely not sure of this i'm just speculating. If that's the case
> then the reports are slowing down because of something else.
>
> --
> modjoe23
> ------------------------------------------------------------------------
> modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376
> View this thread: http://www.excelforum.com/showthread...hreadid=401555

--

Dave Peterson