Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[Excel] Using the (Name) property

Thread starter Skullmonkey
Start date Jun 12, 2002

Status: Not open for further replies.

Jun 12, 2002

Skullmonkey

Computer

I'm interested in writing code in which I can use the name I've given to a particular object inside the VBAProject window. For instance, when looking at the Properties of a chart in the VBA Editor | VBAProject Explorer, one sees many options, one of which is called "(Name)".

Does anyone know how to use this property inside of VBA code? If my declaration of this chart did not include the tab name, the code would not fault if the user renamed the tab.