You can use the so-called "camera tool".
Try this tip:
Quote from the link above:
"...The Camera tool is most often used to overcome Excel's problem with
printing non-contiguous ranges. As you may know, when you try to print
non-contiguous ranges, Excel insists on printing each area on a separate
sheet of paper. You can use the Camera tool to create linked pictures of the
ranges on a separate worksheet. You can then print the pictures on a single
sheet of paper..."
From: Gerena, Dan [mailto:[log in to unmask]]
Sent: 22 April 2002 20:54
To: [log in to unmask]
Subject: Printing across pages
I have 2 worksheets (A & B) that are each split into a monthly and ytd
I want to setup 1 print macro to print the top half of A then B, and then
the bottom half of A then B. Is there a way to do that without specifying 4
different print ranges and jumping from sheet to sheet to do this?
Can't I put a page break to separate the mtd and ytd data on each sheet,
then print the top half then bottom half of each?