Split Print Area - One Page Print
 

Cross posted to microsoft.public.excel.programming. This group is for the
use of VBA in Word

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Cyhill" wrote in message
...
Is it possible to print two ranges in excel to one page. For example...in
my
report template, I would like to print cells A164:P176,A201:P233 on one
page.

I have a dynamic report template in excel which allows users to
select certain employee groups and displays the necessary info based on
their
selections. I am trying to exclude the section where the selections are
made
as it takes up a lot of space, and contains detail that is not needed in a
final printed
report.

I'm not finding a lot of options in the page setup, or proerties within
excel.Is their any other way to have a polished end user report print
separate ranges on one tab. Any options in the Page setup, or suggestions
on
how to code this in VBA?

Split Print Area - One Page Print
 

To the original poster...

In your case, you could hide rows 177:200 and then print A164:P333. But remove
any manual page breaks before you print--even in the hidden rows.

You could record a macro when you hide the rows, print the area you want and
unhide those rows and you'll have the syntax you need.

Doug Robbins - Word MVP wrote:

Cross posted to microsoft.public.excel.programming. This group is for the
use of VBA in Word

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Cyhill" wrote in message
...
Is it possible to print two ranges in excel to one page. For example...in
my
report template, I would like to print cells A164:P176,A201:P233 on one
page.

I have a dynamic report template in excel which allows users to
select certain employee groups and displays the necessary info based on
their
selections. I am trying to exclude the section where the selections are
made
as it takes up a lot of space, and contains detail that is not needed in a
final printed
report.

I'm not finding a lot of options in the page setup, or proerties within
excel.Is their any other way to have a polished end user report print
separate ranges on one tab. Any options in the Page setup, or suggestions
on
how to code this in VBA?





--

Dave Peterson