Control Of Horizontal Page Break

[Chuckles123]

When clicking on 'View - Page Break Preview', I am able to drag the page
break to the right one column, so that all of the columns in my 'Print
Area' are printed on the first page. Why is this so, and can I control
this from VBA?

Thanks for a response,
Chuckles123

 

[Jim Rech]

The way to control the number of pages that are printed is with the Page tab
of File, Page Setup. In the Scaling section select Fit To and the number
wide and/or long to be used. You can record a macro as you manually adjust
this setting to get the VB syntax. Note that when you use Fit To Excel
ignores any manual page breaks you might have added.

--
Jim Rech
Excel MVP
|
| When clicking on 'View - Page Break Preview', I am able to drag the page
| break to the right one column, so that all of the columns in my 'Print
| Area' are printed on the first page. Why is this so, and can I control
| this from VBA?
|
| Thanks for a response,
| Chuckles123
|
|
| --
| Chuckles123
| ------------------------------------------------------------------------
| Chuckles123's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14948
| View this thread: http://www.excelforum.com/showthread.php?threadid=319474
|

 

[Chuckles123]

Jim,
Thanks.
I saw some code on another thread dealing with resetting all pag
breaks and then setting them according to specified cell locations.
I think I will try that.
Chuckles12