Print Landscape AND Portrait Orientation in ONE Worksheet
 

Hi Randall

Thanks for your very prompt response. My problem is that I don't know
how to determine intFrom and intTo.

Regards

Paul Martin
Melbourne, Australia

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Print Landscape AND Portrait Orientation in ONE Worksheet
 

Hi Paul,
By default Excel prints from the top left corner, down until the end of the
printarea.
Then it moves to the next column and repeats.

You can change this in pagesetup so it will print left to right first and
the move down and repeat.

To see your pages with page numbers, do viewpagebreak preview once the
printarea is assigned.

--

John

johnf202 at hotmail dot com


"Paul Martin" wrote in message
...
Hi Randall

Thanks for your very prompt response. My problem is that I don't know
how to determine intFrom and intTo.

Regards

Paul Martin
Melbourne, Australia

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!