Names.Item method (Excel)
Returns a single Name object from a Names collection.
Syntax
expression.Item (Index, IndexLocal, RefersTo)
expression A variable that represents a Names object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Index | Optional | Variant | The name or number of the defined name to be returned. |
| IndexLocal | Optional | Variant | The name of the defined name, in the language of the user. No names will be translated if you use this argument. |
| RefersTo | Optional | Variant | What the name refers to. You use this argument to identify a name by what it refers to. |
Return value
A Name object contained by the collection.
Remarks
You must specify one, and only one, of these three arguments.
Example
This example deletes the name mySortRange from the active workbook.
ActiveWorkbook.Names.Item("mySortRange").Delete
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for