View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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