Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 8. Create and Manipulate Names in VBA

IN THIS CHAPTER

Excel Names	143
Global Versus Local Names	143
Adding Names	144
Deleting Names	146
Adding Comments	146
Types of Names	147
Hiding Names	152
Checking for the Existence of a Name	152
Next Steps	154

Excel Names

You’ve named ranges in a worksheet by highlighting a range and typing a name in the Name box to the left of the formula field. Perhaps you’ve also created more complicated names containing formulas—such as for finding 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: You can store, for example, a new range ...