Slow macro after using printerdriver

  • Thread starter Thread starter Claus
  • Start date Start date
C

Claus

Hello,

My macros are running really slow (factor 10 and upwards) after page preview
or print.

How do I resolve this ?


Kind Regards

Claus Persson
 
Add something like:

ActiveSheet.DisplayPageBreaks = False

Those little dotted lines you see after you print/print preview are the problem.

When you're inserting or deleting rows/columns, excel will try to figure out
where to place those dotted lines. If you do lots of deletions, then excel will
have to do it lots of times.
 
Back
Top