R rickey24 Oct 6, 2004 #1 Thanks Tom works great. Out of curiosity, what does the .Address(External:=True) do to th code
T Tom Ogilvy Oct 7, 2004 #2 ? ActiveCell.Address $B$25 ? activeCell.Address(external:=True) '[Book1]Sheet1 (2)'!$B$25