| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting shapes
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting shapes
activesheet.drawingobjects.group
or activesheet.drawingobjects.Select "Daniel Bonallack" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| Shapes | Excel Discussion (Misc queries) | |||
| Manipulating shapes | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
