Thanks Tom works great.

Out of curiosity, what does the .Address(External:=True) do to th
code

--
rickey2
-----------------------------------------------------------------------
rickey24's Profile: http://www.excelforum.com/member.php...fo&userid=1035
View this thread: http://www.excelforum.com/showthread.php?threadid=26697

? ActiveCell.Address
$B$25
? activeCell.Address(external:=True)
'[Book1]Sheet1 (2)'!$B$25

--
Regards,
Tom Ogilvy


"rickey24" wrote in message
...

Thanks Tom works great.

Out of curiosity, what does the .Address(External:=True) do to the
code?


--
rickey24
------------------------------------------------------------------------
rickey24's Profile:
http://www.excelforum.com/member.php...o&userid=10359
View this thread: http://www.excelforum.com/showthread...hreadid=266971