Try this:

with activesheet
msgbox .range("a1").address
msgbox .range("a1").address(0,0)
msgbox .range("a1").address(external:=true)
end with

And you'll see what it does.



"CAA <" wrote:

Cheers Dave

That's nearly exactly as i've put it, however i don't have a clue what
the (external = true) is for, I looked it up and found it means
external referance.
I don't know what that means for excel, I use Autocad and an external
referance is part of the drawing that is a copy of another drawing,
when the other is updated then the changes are reflected in your
current drawing, is this similar for Excel?

CAA

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson