Excel.ConnectorFormat.EndConnected.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ConnectorFormat.EndConnected property (Excel)	vbaxl10.chm646080	vbaxl10.chm646080	Excel.ConnectorFormat.EndConnected	e0831e66-f392-5044-0931-97bdab4de9c2	04/23/2019	medium

ConnectorFormat.EndConnected property (Excel)

msoTrue if the end of the specified connector is connected to a shape. Read-only MsoTriState.

Syntax

expression.EndConnected

expression A variable that represents a ConnectorFormat object.

Example

If the end of the connector represented by shape three on myDocument is connected to a shape, this example stores the connection site number in the variable oldEndConnSite, stores a reference to the connected shape in the object variable oldEndConnShape, and then disconnects the end of the connector from the shape.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3) 
    If .Connector Then 
        With .ConnectorFormat 
            If .EndConnected Then 
                oldEndConnSite = .EndConnectionSite 
                Set oldEndConnShape = .EndConnectedShape 
                .EndDisconnect 
            End If 
        End With 
    End If 
End With

[!includeSupport and feedback]