Axes.Parent property (Excel)

Returns the parent object for the specified object. Read-only.



expression A variable that represents an Axes object.


This example displays the name of the chart that contains myAxis.

Sub DisplayParentName() 
 Set myAxis = Charts(1).Axes(xlValue) 
 MsgBox myAxis.Parent.Name 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.