If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Harlan checks to see if the returned value is #ref. If it doesn't return that
error, then it means that the workbook is already open and you don't need his function. But even worse, I gave you a link to an older version (sorry). http://groups.google.co.uk/groups?se...wsranger.co m should work better. " wrote: Okay - I think I finally got it to work. It actually was something simple - I had double quotation marks around the parameter being passed to the pull function - which is wrong. It should be a single quotation mark at the beginning around the path, file name and sheet name, ending before the ! and cell reference. Once I took out the double quotation marks it works fine. I misread it on the previous post. I just have one other question - in Harlan Groves function he is checking for the cell to have a #REF error in it before pulling the value from another workbook. Any reason to do this? This was also giving me some problems at first - sometimes I would have a #REF error and sometimes I would have a #VALUE error. Any reason to have to check for these errors at all? Once agin, thanks to all who have helped me with this. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating multiple worksheets in a large workbook | Graham | General Discussion | 3 | February 11th, 2005 10:29 AM |
2003 update link when Source open | Ausrobbo | Worksheet Functions | 0 | January 17th, 2005 06:25 AM |
How do I set up a Workbook with a master compiled worksheet and o. | Double D Racing | Worksheet Functions | 1 | November 19th, 2004 06:03 AM |
Writing a macro to change external links to manual updating in Excel 2000 | John Wirt | Links and Linking | 5 | February 16th, 2004 08:03 AM |
Chart Linked to Other Workbook Not Updating | Michael W. | Charts and Charting | 2 | February 5th, 2004 01:44 PM |