Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I parse the data in a cell | Excel Discussion (Misc queries) | |||
help - need to parse a cell | Excel Worksheet Functions | |||
How do I parse the cell reference function? | Excel Worksheet Functions | |||
Parse cell contents ? | Excel Discussion (Misc queries) | |||
Parse ST-ZIP Cell (15,427 times...) | Excel Discussion (Misc queries) |