Strings

When using names to hold strings, such as the name of the current fruit producer, enclose the string value in quotes. Because there is no formula involved, an equal sign is not needed: Names.Add = "Company", Refersto:="CompanyA"

Figure 7.6 shows how the coded name would appear in the Define Name window.

Figure 7.6

A string value can be assigned to a name.

Figure 7.6 shows how the coded name would appear in the Define Name window.

0 0

Post a comment