VBA and Macros: Microsoft® Excel® 2010

8. Create and Manipulate Names in VBA

IN THIS CHAPTER

Excel Names

Global Versus Local Names

Adding Names

Deleting Names

Adding Comments

Types of Names

Hiding Names

Checking for the Existence of a Name

Excel Names

You have probably named ranges in a worksheet by highlighting a range and typing a name in the Name box to the left of the formula field. You also might have created more complicated names containing formulas. For example, perhaps you created a name with a formula that finds the last row in a column. The ability to set a name to a range makes it much easier to write formulas and set tables.

The ability to create and manipulate names is also available in VBA and provides the same benefits as naming ranges in a worksheet. For example, ...