Posted to microsoft.public.excel.programming

Barb Reinhardt Barb Reinhardt is offline

external usenet poster

Posts: 3,355

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very slow Visual Basic code execution in new Excel 2007	JLatham	Excel Programming	6	October 7th 09 09:45 PM
Issue with code execution -- it is very slow	robs3131	Excel Programming	7	June 8th 07 11:46 PM
Execution very slow	jimmy[_5_]	Excel Programming	4	March 4th 07 09:04 PM
Slow code execution	side_	Excel Programming	2	October 21st 05 06:44 PM
slow macro execution	Vasile Dumitrescu	Excel Programming	1	October 7th 03 03:31 PM

All times are GMT +1. The time now is 08:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us