Hi Peter

sounds like Ron's solution worked - however, please feel free to post back
if you have any further queries.

Cheers
JulieD

"Peter" wrote in message
...
Hello again, and thankyou for the replies so far.
I wish it was as simple as just being able to hide the rows I don't need
to
print, problem is 99% of the people about to use what I am doing have zero
computer skills..anything other then filling in a text box is out of the
scope for them.

Julie, I do have the page setup as it needs to be, it's just the printing
part that has me baffled. After I select the cells that need to be
printed,
(in diffrent area's on the page) it breaks the single page into five small
pages. Using the Page break preview shows exactly that.

What I really need to be able to do, is select the cells required, and
have
them all print to the same page in their current position. I was hoping
there
was a macro or similar to allow this. I have tried everything I can think
of...

Regards
Peter

"IanRoy" wrote:

Hi, Peter;
If your worksheet already has the data you want to print in the right
positions for your pre-printed forms,try something like this: copy the
contents of that sheet and Paste Special Formats into a new sheet. Then
copy
and Paste Special Paste Link from only the cells you want to print into
the
matching cells on your new sheet. Then use that one for printing.
Regards,
IanRoy.

"Peter" wrote:

Hello,
I have a single excel worksheet, and due to area's of the sheet I do
not
want to have printed, (the data is to be printed onto pre printed
forms),
have used the set print area option to exclude those area's.

The problem is now I have multiple pages inside a single worksheet.
Each
page prints seperatly, so I end up with 5 pages with only a small
amount of
the full worksheet on each.

Thanks in advance
Peter