Select multiple charts to be copied

I am trying to select 2 charts on my worksheet simultaneously so I can copy them into word via vba. Manually its no problem, select 2nd chart while pressing the ctrl button, but how do you do this programmatically via vba.

I tried your code with a minor change (chart number). But nothing gets selected. The changes I made are below.

Please Login or Register  to view this content.

2007, I should have mentioned that initially.

Perfect, that works great! Thanks Andy.