What does Address(external:=True) mean?
 

What does the data in the bracket denote?

rng.Address(external:=True)

I usually only use the .Address property without any additional information.
MSDN states "Optional Variant. True to return an external reference. False
to return a local reference. The default value is False."

What is an external/local reference?


Thanks

EM

What does Address(external:=True) mean?
 

Try this in the immediate window:

?activecell.address
then
?activecell.address(external:=true)

And you'll see the difference.


ExcelMonkey wrote:

What does the data in the bracket denote?

rng.Address(external:=True)

I usually only use the .Address property without any additional information.
MSDN states "Optional Variant. True to return an external reference. False
to return a local reference. The default value is False."

What is an external/local reference?

Thanks

EM

--

Dave Peterson

What does Address(external:=True) mean?
 

I guess I could have done that prior to my post! Thanks

EM

"Dave Peterson" wrote:

Try this in the immediate window:

?activecell.address
then
?activecell.address(external:=true)

And you'll see the difference.


ExcelMonkey wrote:

What does the data in the bracket denote?

rng.Address(external:=True)

I usually only use the .Address property without any additional information.
MSDN states "Optional Variant. True to return an external reference. False
to return a local reference. The default value is False."

What is an external/local reference?

Thanks

EM

--

Dave Peterson