O'Reilly logo

VBA and Macros for Microsoft Excel by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7Names

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 a dynamic table. 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 in a name.

This chapter explains different types of names and the various ways they can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required