<div>Hi,<br/><br/>i have a workbook that contains multiple chart sheets and worksheets. i like to export the selected charts as well as the ranges of worksheets in pdf format in ONE pdf file. is there any way to do that?<br/><br/>Thanks!</div>© 2009 Microsoft Corporation. All rights reserved.Fri, 10 Jul 2009 09:19:07 Z36630c86-1c35-40b7-bd80-63383f5f9483http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/36630c86-1c35-40b7-bd80-63383f5f9483#36630c86-1c35-40b7-bd80-63383f5f9483http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/36630c86-1c35-40b7-bd80-63383f5f9483#36630c86-1c35-40b7-bd80-63383f5f9483bbxxkkhttp://social.msdn.microsoft.com/Profile/en-US/?user=bbxxkk<div>Hi,<br/><br/>i have a workbook that contains multiple chart sheets and worksheets. i like to export the selected charts as well as the ranges of worksheets in pdf format in ONE pdf file. is there any way to do that?<br/><br/>Thanks!</div>Thu, 09 Jul 2009 17:53:29 Z2009-07-09T17:53:29Zhttp://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/36630c86-1c35-40b7-bd80-63383f5f9483#ac1b79aa-7a25-469b-9c9a-dd3814030cd6http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/36630c86-1c35-40b7-bd80-63383f5f9483#ac1b79aa-7a25-469b-9c9a-dd3814030cd6Andy Popehttp://social.msdn.microsoft.com/Profile/en-US/?user=Andy%20PopeHi,<br/> <br/> Do you group the sheets when creating the pdf?<br/> <br/> Select the first tab and then with the shift key held click the last tab to be grouped.<hr class="sig"> Cheers www.andypope.infoFri, 10 Jul 2009 09:19:05 Z2009-07-10T09:19:05Z