No, I think it was just written to handle single cells. I will suggest to
Harlan that he enhances it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DaveO" wrote in message
...
Hi Bob, thanks for the help here on this function.

I've read the VBA and gone through it and have a basic understanding of
whats going on here. However, the PULL function can't handle arrays of
data
by the looks of it. By this I mean that the pull function needs to return
an
array of data as it exists inside of a VLOOKUP function.

Any more ideas at all please?

TIA.

"Bob Phillips" wrote:

Take a look at Harlan Grove's PULL function that does do that

ftp://members.aol.com/hrlngrv/
Look for pull.zip


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DaveO" wrote in message
...
Using the INDIRECT function I'm trying to reference data in another
Workbook.
However, if that workbook is not open the function returns a #REF!
value.
Open the Workbook it's referencing and it happily returns the vlaue I
need. I
understand it's one of the volatile functions in Excel, but I don't
know
why
it won't return return the value if the other sheet is not open.

Any ideas to help at all please??

TIA.