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
|