Select Specific Objects

[JonesyUK]

Hi - I've got a number of charts and objects on 1 Excel sheet.

I need to transfer theses to Powerpoint and in order to do this, I hold ctrl+each chart and object. This is quite a lengthy procedure.

Is there VBA which I can run to select the charts and objects?

Example , I have 200 Charts. I want to select Charts 1 to 20, as well as 2 text boxes.

I will then copy this and paste to powerpoint...

Hope this makes sense.

Many thanks,
CJ

 

[Ruddles]

If you select one of them and press Ctrl-A, does that not do it?

Edit: sorry, ignore me - you don't want them all.