Hi Jack

Do you have the same problem if you use
IgnorePrintAreas:=False in the code examples here

http://www.rondebruin.nl/pdf.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Jack_Sprat" wrote in message ...
When I create a small one page speadsheet in Excel 2007, and print it, it
prints fine - all on one page. However, if I save this document as a PDF
file, the last column gets clipped and put onto a second page. The print
area is set to include the entire worksheet. The PDF processor is that
downloaded from the MS site for Office 2007.

Is there any way of producing the PDF file so that it will fit onto only one
page, in a similar manner as saving and printing from Excel? I cannot find
any PDF options to fit to page.

The document in question can be seen on my skydrive at:
http://cid-8f2c74bf2c0b9544.skydrive...0Mar%2007.xlsx