Parse cell reference
 

Steve,

I think that is old Lotus notation. Just remove it, it is not necessary.

What do you want to retrieve from that sheet. You should specify a cell on
that sheet to store in A1, and then you would just put this in A1
='C:\Contracts\[CCO Form 072803.xls]Contract Changes MAY-03'!$N$471
or some other cell.

--

HTH

Bob Phillips

"Steve" wrote in message
thlink.net...
I have the following reference in cell J19:
=+'C:\Contracts\[CCO Form 072803.xls]Contract Changes MAY-03'!$N$471

Two questions ---
1. What is the "+" for?

2. What is the code to retrieve
=+'C:\Contracts\[CCO Form 072803.xls]Contract Changes MAY-03'
and put it in cell A1?

Thanks for all your help!

Steve