Using local properties

If your code will display worksheet information such as a formula or a range address, you probably want to use the local language. For example, the following statement displays the formula in cell A1:

MsgBox Range("A1").Formula

For international applications, a better approach is to use the FormulaLocal property rather than the Formula property:

MsgBox Range("A1").FormulaLocal

Several other properties also have local versions. These are shown in Table 26-3 (refer to Help system for specific details).

Table 26-3 PROPERTIES THAT HAVE LOCAL VERSIONS

Property

Local Version

Return Contents

Address

AddressLocal

An address

Category

CategoryLocal

A function category

Formula

FormulaLocal

A formula

FormulaR1C1

FormulaR1C1Local

A formula, using R1C1 notation

Name

NameLocal

A name

NumberFormat

NumberFormatLocal

A number format

RefersTo

RefersToLocal

A reference

RefersToR1C1

RefersToR1C1Local

A reference, using R1C1 notation

0 0

Post a comment