VBA Question

[Gary_E]

General question

Does anyone know the difference between using Address vs. AddressLocal ? They both seem to generate the same results

Sample code*******************
aaa = ActiveCell.Address
bbb = ActiveCell.AddressLocal

[Juan Pablo González]

From Help:

AddressLocal Property

Returns the range reference for the specified range in the language of the user. Read-only String.



Example

Assume that this example was created using U.S. English language support and was then run in using German language support.

The example displays the text shown in the comments.



Set mc = Worksheets(1).Cells(1, 1)

MsgBox mc.AddressLocal()                         ' $A$1

MsgBox mc.AddressLocal(RowAbsolute:=False)       ' $A1

MsgBox mc.AddressLocal(ReferenceStyle:=xlR1C1)   ' Z1S1

MsgBox mc.AddressLocal(ReferenceStyle:=xlR1C1, _

    RowAbsolute:=False, _

    ColumnAbsolute:=False, _

    RelativeTo:=Worksheets(1).Cells(3, 3))       ' Z(-2)S(-2)



-----------------

Address Property

Returns the range reference in the language of the macro. Read-only String



Example

Example

The following example displays four different representations of the same cell address on Sheet1.

The comments in the example are the addresses that will be displayed in the message boxes.



Set mc = Worksheets("Sheet1").Cells(1, 1)

MsgBox mc.Address()                              ' $A$1

MsgBox mc.Address(RowAbsolute:=False)            ' $A1

MsgBox mc.Address(ReferenceStyle:=xlR1C1)        ' R1C1

MsgBox mc.Address(ReferenceStyle:=xlR1C1, _

    RowAbsolute:=False,     _

    ColumnAbsolute:=False,  _

    RelativeTo:=Worksheets(1).Cells(3, 3))        ' R[-2]C[-2]

_________________
Regards,

Juan Pablo G.
MrExcel.com Consulting

[ This Message was edited by: Juan Pablo G. on 2002-02-21 20:07 ]

[Gary_E]

thxs for the tips, but in plain language - Any difference between the 2 ?

[NateO]

Local appears to be based on your language settings. The other is based on universal settings (as decided in Seattle, Wa).

Cheers,
Nate

[ This Message was edited by: NateO on 2002-02-21 20:22 ]

[Gary_E]

Thxs Nate
(I think)

[NateO]

Too techie?

Bottom line =

Stay away from the local.

Cheers,
Nate

[ This Message was edited by: NateO on 2002-02-21 21:14 ]