Copy several charts to pdf vba

[adde86]

Hi,

I have one worksheet with several charts in it. I want to copy some of these specific charts into one pdf using vba.
Is it possible?
It would also be great if it is also possible to post two charts next to each other in that same pdf.

Thanks
Andreas

 

[Stiuart_W]

What you can do is export a worksheet as a pdf page. Also you can make charts visible or invisible. If they are invisible then they won't appear in the pdf

No doubt you could move one or more charts so they were next to each other.

If you want help with the code you'll obviously need to provide far more information

 

[adde86]

Thanks for answer.
Sheet is called "Grafer" and I want to copy Chart 1-3 to a pdf. And I also want to copy range AO36:BA64 which is text into the same pdf.
And the pdf should be visible after publishing. I have managed to just copy the printarea into the pdf but the charts didn´t work.
Do you need more info?

 

[Stiuart_W]

I would suggest you write a macro that creates a temporary Worksheet, copies the text range and the 3 charts and pastes these where you want them in the temporary sheet. Then saveas pdf and then delete the sheet