"Jock" wrote in message
...
Hi
I have been trying to do some thing along the same lines.
have a look he
http://www.lebans.com/reporttopdf.htm

Also search Win2PDF as an alternative.

Regards,

Have encountered this when printing "Entire Workbook" and there is a change
in some "Page Setup" properties from one sheet to the next - in my case it
was Print Quality - not sure what other ones can cause it - (but not
Orientation or Paper Size).

HTH