Hi Mark

See if your used range is not to big
Is the shortcut

Ctrl-end

Select the last cell with data ?

If you send a selection do you have the same problem then ?
I have code examples here to test
http://www.rondebruin.nl/pdf.htm


--

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




"Mark" wrote in message ...
In 2003 I used Acrobat Distiller in marcos and created a pdf file of 300 kb.
When I used the same code in 2007 I ended up with a pdf file size of 14,000
kb. In 2007 I tried ExportAsFixedFormat with minimum quality and get a file
size on the same worksheet of 900 kb. Is there any way to reduce the pdf
file size?

__________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com