Working with several charts in VBA

[Pepen]

Hi there, I need to move a cluster of graphs around at once and print them to PDF, is there any straight-forward way of doing this in VBA?

I know how to print a sheet to PDF in VBA, so I suppose a solution could be simply to move the needed charts to a new sheet, then print it to PDF before deleting it again. I just don't know how to do this with VBA..
Thanks in advance

 

[Pepen]

I'll bump it up, with some more info. If I just try and record a marco, where I select multiple Charts, then paste 'em on to a new sheet, I only get:

ActiveSheet.ChartObjects("Chart 3").Activate
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Paste

So it seems to not register that I mark the other charts at all.