Figure

You can set up names that refer to a value rather than a cell or range on a worksheet.

Define Name

B

I Names In ¡¡¿ortbocfc.:

SalesTaxRate

1 OK 1

Filial 'Tcol

NyM^nth

i Close

m 1

. Ijlelete J

1 Refers to:

1 =0.06

When you use the name in the workbook, you get the value you assigned to it.

Figure 13.3

When you use the name in the workbook, you get the value you assigned to it.

E3 Microsoft Office Excel Z0G3 Beta - Chapter 13 Examples,«!

m

Fils Edt

Vkw Insert Format

Tools Window -Vt

.5x1

1 -j

,i -I -.' "-ü J I ¿ä X il ■-■:

1 : • 8 Iföld

A2

ft "SalesTaxRate

A

B

C I

D

E

F

G7

1

2

0.061

3

J

5

H 1

> M \>l>eetl /»ee»2 /5heet3 /-street* /,\<

t,i ü 1

Jii

I Ready

If you do use this method of storing values, you need to use the Evaluate method of the Application object to retrieve the value associated with the name. Listing 13.2 demonstrates this.

0 0

Post a comment