Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below works fine…
Dim shpGroup(10) As Shape Dim shpTemp As Shape Dim element For element = 1 To 10 Set shpGroup(element) = ActiveSheet.Shapes(element) If shpGroup(element).Type = msoGroup Then For Each shpTemp In shpGroup(element).GroupItems Debug.Print "index = " & element, " group " & shpGroup(element).Name, shpTemp.Name Next shpTemp Else Debug.Print "index = " & element, " shape ", , shpGroup(element).Name End If Next element but statement… For Each element In ActiveSheet.Shapes(Count) '? .Count .Index gives error <index unavailable Any possible reason ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) | |||
VBA code to count colors/shapes? | Excel Programming | |||
How can I loop to find the grouped shapes count | Excel Programming |