My VBA knowledge is very limited (usually to the record/stop button on the
macro toolbar). I have copied the code to a new module in my workbook, and
the pull function appears in my UDF list. As a way of a test, I am just
trying to reference one cell in a closed workbook using a string in A1, and
=pull(a1) in another cell. Howewer, all i get is #value. Have tried with an
open workbook, with and without the file path, with & without apostrophes....
Any suggestions?

I get the feeling I'm over-complicating things now, but i've got this far....

"Bob Phillips" wrote:


"Arvi Laanemets" wrote in message
...

b) Some frequent resident of Excel NG's (I don't remember who) has an UDF
or
Add-In on his site to download, which is an equivalent for INDIRECT, but
works with closed workbooks too. But when you want to design a workbook
for
use by several users, all of them must have it in their computers - which
can be a problem.

That would be Harlan Grove who wrote a UDF called PULL.

You can find the function at his FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip