O'Reilly logo

Excel 2003 VBA Programmer's Reference by Robert Rosenberg, Rob Bovey, John Green, Stephen Bullen, Paul T. Kimmel

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

20

Using Names

One of the most useful features in Excel is the ability to create names. You can create a name using the Insert images Name images Define…dialog box. If the name refers to a range, you can create it by selecting the range, typing the name into the Name box at the left-hand side of the Formula Bar and pressing Enter. However, in Excel, names can refer to more than just ranges.

A name can contain a number, text, or a formula. Such a name has no visible location on the worksheet and can only be viewed in the Insert images Name images Define…dialog box. Therefore, you can use names to store information in a workbook without having to place the data in a worksheet cell. Names can be declared hidden so that they don't appear in the Insert images Name images Define…dialog box. This can be a useful way to keep the stored information unseen by users.

The normal use of names is to keep track of worksheet ranges. This is ...

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