I am looking for a solution similar to the one in this thread.

http://www.excelforum.com/excel-prog...orksheets.html

Only difference is I need to export to PDF. I have attempted to modify the code provided with no luck.

Thanks,