View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Execution slow around PageBreak Code

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