I will try to sort on info you have given.

Reason for 5 pages is that the five sections relate to monday - friday and I
want each day seperate, its nothing complicated just names and addresses so
no formulas or anything.


"Duke Carey" wrote in message
...
Is there some reason you can't set the entire print range at once? Are
the 5
ranges discontiguous?

If that's the problem, name each of the 5 ranges, something like Page1,
Page2, etc. Then go to File - Page Setup and navigate to the Sheet tab.
In
the Print Area box type all the range names separated by commas:

page1, page2, page3, page4, page5

Now each range will print on a separate page.

"Scudo" wrote:

On a spreadsheet due to the size of it takes 5 pages to print it off.
Currently I `set` each page as a print area then print so I have to do
this
5 times in order to print off the full spreadsheet page. Is there a way
to
press `print` and it will print off the 5 pre set `print areas` ?
without me
having to go throught the `set print area` / `print`/`clear print area`
then
reset for next section.

thanks