Execution slow around PageBreak Code

B

Barb Reinhardt

I have the following code

For each myPageBreak in myWS.HPageBreaks.
blah blah blah
next myPageBreak

I've toggled to page break preview before executing this and it's VERY slow
executing the FOR line. Does anyone have any idea why this might be. The
worksheet I'm referring to as myWS has at most 4 HPageBreaks in it.

Thanks,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slow Code Execution 4
Unwanted Sub Exit, Ws in page break preview View 0
slow code execution 0
Slow running SQL via ADO connection in excel 2
HOWTO Time VBA code 19
Break points will be ignored in Excel 1
Code Execution Inexplicably Stops & Excel Soon Crashes 0
Code Execution Has Been Interrupted 3

Top