Selecting shapes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a macro that will group every drawing object on the page (and it will
be a different number each time).

So I recorded a macro by selecting two rectangles...
ActiveSheet.Shapes.Range(Array("MyRect97", "MyRect96")).Select

Then I attempted to build the array set differently, but it didn't work
myShape = "MyRect97" & """" & "," & """" & "MyRect96"
ActiveSheet.Shapes.Range(Array(myShape)).Select

Can you tell me how I to populate the variable "myShape" correctly?
Thanks in advance.

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Shapes 3
Selecting All AutoShapes on a Worksheet 1
floating button 6
Class factory desing question 10
Changing the test of checkboxes (shapes) programmatically? 3
select shape range 2
trouble with selecting ActiveSheet.Shapes.Range 20
Using VBA to navigate slides in a presentation? 8

Back
Top