Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the name of a group given the reference to a shape within the group
I have a series of drawing objects connected by connector lines. I am
using the following to retrieve the name of the object connected by the line: dim sh as shape For Each sh In ActiveSheet.Shapes debug.print sh.ConnectorFormat.BeginConnectedShape.Name Next However, for grouped objects this returns the name of the sub item which the connector is attached to rather than the group name, eg. "Line32" is returned rather than "Group15", where Line32 is contained within Group15. Is there any way to determine the name of the group that a particular object making up that group is in? Thanks a lot, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Reference oleobject within shape group | Excel Programming |