Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Shapes
Hi, Just can't figure how to group shapes of a sheet.. something like: For i = 1 To ActiveSheet.Shapes.Count If Left(ActiveSheet.Shapes(i).Name, 6) = "Forme " Then AddtoGroup Next i I can do this: ActiveSheet.Shapes.Range(Array("Shape1", "Shape2")).Select Selection.ShapeRange.Group.Selec But the "Array" part in my case is variable and I can't find how to pu a variable instead of Array("Shape1", "Shape2")). Thank ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | 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) |