Posted to microsoft.public.excel.programming

Deeds

external usenet poster

Posts: 113

Setting print range with macro

I am trying to clear a sheet of all print range and page breaks...then set
the print range and tell it where to page break both vertical & horizontal.
Can someone please give me basic code for setting the print range and
adjusting the page breaks. Print range: A1:Q154 and the page break must be
set to row 96. 1page wide by 2 pages tall. Thanks in advance!

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
Macro in VBA: Setting a variable print range HELP NEEDED!!	Ron de Bruin	Excel Programming	1	July 21st 04 05:45 PM
Setting print range using VBA	Dave Ramage[_2_]	Excel Programming	0	July 29th 03 04:35 PM
Setting print range using VBA	VBANut	Excel Programming	0	July 29th 03 04:20 PM
Setting print range using VBA	Ron de Bruin	Excel Programming	0	July 29th 03 03:59 PM
Setting Print range	Tom Ogilvy	Excel Programming	3	July 25th 03 04:06 AM

All times are GMT +1. The time now is 01:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us