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