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