Hi Balcott

You can try
http://www.rondebruin.nl/print.htm#non-contiguous

--

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


"Balcott" wrote in message ...
I have a print area in each of 5 different worksheets of the same file. Would
like to create a macro to print all ranges simultaneously (all into one PDF
file, or as a complete report to a printer).
The file is also distributed to our customers for their use, and I want to
allow them the same print function (hence a macro button is handy).
Any suggestions?

Thanks
Bob