Thanks Dave, I will look at all that and pass it on.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DaveO" wrote in message
...
I've spent the past hour or so just going through the code Bob and have
found
an answer.

In the code at the very end Harlan has a line that reads ...

pull = r.Value

I've altered this in my code to now read ...

pull = r.Value2

and it allows array values. Perhaps a quick check of the variables (using
a
simple IF) would enhance this to be able to be used in all situations.

Also, a quick caveat in case you do speak to him about this. I'd suggest
that somewhere in the code he tries to tell the suer to limit the array
that
is returned to an absolute minimum else the function will take a long time
to
return a value. Only trying to help out here and certainly don;t wish to
seem
ungrateful for what is a great bit of code!

Thanks again!

Dave.



"Bob Phillips" wrote:

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.