Help selecting all charts in a worksheet

[Andrew Entee]

I have 10 charts on a worksheet. Can anyone tell me the best VBA way to select, copy and paste them all simultaneously onto another sheet (as opposed to one at a time)? Thanks!

[xlnitwit]

If you are doing it in VBA why does it matter whether you do them all at once or in a loop? Just curious.

Please Login or Register  to view this content.

would be equivalent to the manual method.

[Andrew Entee]

Thanks xinitwit... you've help me before also... much appreciated. I'll try to get that working and marked solved then.
cheers

[Andrew Entee]

Sorry forgot to answer your questions... I was just looking for the most efficient way to handle the process. Your suggestion looks to be much more efficient than a loop.