You can do this maybe
http://www.rondebruin.nl/print.htm#non-contiguous

Then use that worksheet to create the PDF
See
http://www.rondebruin.nl/pdf.htm

--

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


"Cresta" wrote in message ...
Excel vba (Save As PDF / XPS)
Is it posible to merge more than one named range on different sheets to one
pdf file. ie Sheets(1).Range("Name1") and Sheets(2).Range("Name2")

Or

Is it posible to merge several pdf files into one.

Thanks