What does Address(external:=True) mean?

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
Try this in the immediate window:

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

And you'll see the difference.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot set range class? 8
Help with applying code 5
Regex Pattern to extract Sheet Name from .Address(external:=True) 9
Help with code issues 5
Used Range and Source data of a Pivot Table 1
External:=True 5
When do I need Rng.Address(External:=True) 1
Link to database 2

Back
Top