PULL function (Harlan Grove) - can it use Named Ranges?

[sstackhoTEST]

(hmmm, I posted a message a few hours ago, but it doesn't seem to
have been posted, so I guess I'll try again...)

I would like to use Harlan Grove's PULL function to reference data in
a potentially-closed workbook. (I do not want to use direct links,
as I hope to be able to specify the spreadsheet name and directory in
a cell.)

Can the PULL function refer to a named range in the external
workbook? I have done many Google searches, and found a message from
Harlan that was possiblying impliying it could be done, but I
couldn't get it to work myself. I could only get PULL to work by
using an explicit range like Sheet1!A1:C3.

Thanks,
Shawn


--

 

[Harlan Grove]

(e-mail address removed) wrote...
....

Can the PULL function refer to a named range in the external
workbook? I have done many Google searches, and found a message from
Harlan that was possiblying impliying it could be done, but I
couldn't get it to work myself. I could only get PULL to work by
using an explicit range like Sheet1!A1:C3.

....

As currently written, it can only fetch scalar defined names, i.e.,
single values, not ranges or arrays. I also just found another bug.
Just after the line

If Left(b, 1) = "'" Then b = Mid(b, 2)

you need to add the statement

If Right(b, 1) = "'" Then b = Left(b, Len(b) - 1)

I'm working on pulling arrays and single area range defined names, but
you may want to consider using Laurent Longre's MOREFUNC.XLL add-in
instead, specifically, it's INDIRECT.EXT function.

 

[sstackhoTEST]

Thanks Harlan.

I am hoping to be able to use your function, since that way the code can be a
part of the spreadsheet, and I won't be dependent on the other user having the
DLL...

Thanks again for your help.

Shawn
--

 

[Peo Sjoblom]

You can include Morefunc in the workbook, the new version has a setup file
where you can add a menu to the tools menu, in that menu there is an option
called "embed morefunc in the workbook"


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com