Macro to Select All Shapes in a Specific Range

[ndouglas48]

Hello all! I am trying to create a macro that simply selects all shapes in a specific range, let's say A1:D5. I am able to select all shapes in a given worksheet but need to narrow this to the specific range. Here's the kicker: How can I do this without referencing the specific shape names, i.e. "Oval 4"? I am using macros to create and delete shapes so the names continually change. So this macro needs to search the range and select all shapes that are present within it. Any help is hugely appreciated. Thank you!

ND

 

[Rick Rothstein]

Is there something I could add to this that would automatically group these selected objects after selection?

Just put this statement immediately after the Next statement...

Selection.Group

 

[ndouglas48]

Nevermind! Figured it out! Thanks again for all of your help!

 

[pgc01]

You're welcome. Thanks for the feedback.