Creating a PDF Macro that has each pages area set in it so I can used different Ranges from my sheet?

[tonywatsonhelp]

Hi Everyone,

Go an interesting one I'm hoping I can get help on,

I have a sheet and I want to have a macro create a PDF from that sheet,
However I don't want to create from Just 1 Range using the page set up as this creates lots of Blank spaces and not all the Data is needed in the PDF,

So Heres what I need:

A Macro that will Print out 5 Pages with the print area for each page Set in the Macro,
The Page Print Areas Are:
Page1 A15:G45
Page2 A65:G115
Page3 B120:H165
Page4H166: P224
Page5 A225:G265

If anyone knows how I can do this please help as I've got no other way of Doing this?

Thanks

Tony