Split Print Area - One Page Print

[Cyhill]

Is it possible to print two ranges in excel to one page. For example...in my
report template, I would like to print cells A164176,A201233 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?

 

[Doug Robbins - Word MVP]

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

 

[Dave Peterson]

To the original poster...

In your case, you could hide rows 177:200 and then print A164333. 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.