ExcelBanter - PULL function (Harlan Grove)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - PULL function (Harlan Grove) - can it use Named Ranges? (https://www.excelbanter.com/excel-worksheet-functions/101838-pull-function-harlan-grove-can-use-named-ranges.html)

[email protected]

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

(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

--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Harlan Grove

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

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.

[email protected]

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

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
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Peo Sjoblom

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

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

"Shawn" wrote in message
...
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
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

All times are GMT +1. The time now is 02:37 AM.