Excel.Worksheet.Names.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.Names property (Excel)	vbaxl10.chm175107	vbaxl10.chm175107	Excel.Worksheet.Names	4bdccfa9-7aa1-c3d6-6a89-5ce24aad2ad2	05/30/2019	medium

Worksheet.Names property (Excel)

Returns a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). Read-only Names object.

Syntax

expression.Names

expression A variable that represents a Worksheet object.

Remarks

Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.

Example

This example defines the name myName for cell A1 on Sheet1.

ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _ 
 "=Sheet1!R1C1"

[!includeSupport and feedback]