Posted to microsoft.public.excel.programming

Robert Christie[_3_] Robert Christie[_3_] is offline

external usenet poster

Posts: 117

Insert HPageBreaks

Hi Everyone
Is it at all possible to insert pagebreaks in multiple
places at the same time?
The code below does not work.
Range("A38,74").Select
ActiveWindow.SelectedSheets.HPageBreaks.Add _
Befo=ActiveCell

TIA

Bob XL2002

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
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed	Jamey Weare	Excel Worksheet Functions	1	December 22nd 06 01:40 AM
Is there no one who uses PageBreaks? HPageBreaks?	GeorGeorGe	Excel Worksheet Functions	0	February 11th 05 05:53 PM
HPageBreaks.Add	GeorGeorGe	Excel Worksheet Functions	0	February 9th 05 09:31 PM
Can't set manual HPageBreaks	J.E. McGimpsey	Excel Programming	0	July 15th 03 03:52 PM
Can't set manual HPageBreaks	J.E. McGimpsey	Excel Programming	1	July 14th 03 08:12 PM

All times are GMT +1. The time now is 08:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us