select ALL Shapes

[chibouki]

Hello,
I am looking the way to select all the shapes present in a sheet.
Thx in advance,
David

Please Login or Register  to view this content.

[Leith Ross]

Hello chibouki,

Your title says select, but your code is deleting the objects. This code will delete all shapes on the active sheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[chibouki]

Thx,
I got a syntax error on the line I put in bold.

Please Login or Register  to view this content.

For the futur, would there be a way to specify the Shapes type? For example, deleting only the "Oval"?

Thx again,
David

[royUK]

There's a typo

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

If your shapes are named Oval1, Oval2 etc

Please Login or Register  to view this content.

[Andy Pope]

Another alternative

Please Login or Register  to view this content.

[vashspamster]

This is great, I'm a beginner but needed to remove a ton of shapes that spread like a plague from constant copying and pasting and this did the trick. Thanks Leith Ross and royUK the code below worked a treat!

Please Login or Register  to view this content.