Hello Harlan -

I want to thank you for this post. I really want to understand this
capability, and I can't make it work. It will be a huge shortcut.

local to the worksheet named ' '

I take this to mean there is a worksheet named by the space-bar solely,
name equal to CHAR(32). Since I don't understand why one would do that,
I also take this to be the root of my whole problem. When I try other
constructions such as '' (single quote-single quote), Excel says they
are invalid names.

' '!_WBNAME:
=TRIM(GET.DOCUMENT(1))

Returns the trimmed document name. In my case [Grove1.xls]

' '!_WSLST:
=SUBSTITUTE(GET.WORKBOOK(1),' '!_WBNAME,"")

Returns a 1xN horizontal array of N worksheets' sheet names.
[Grove1.xls] substituted out.

global

WSLST:
=' '!$1:$1

Isn't this local? And I take it refer to Row 1 of sheet space-bar.

_WBWS and WSNAME I understand, though not why the $1:$65536 range.

=INDEX(WSLST,MATCH(WSNAME,WSLST,0)+1)

Returns #N/A for me. It looks to be indexing a list of sheet names, but
I don't see how it was populated. See above.

Sorry to be so dense.

....best, Capt N.

--
Email to (yes, you can so figure it out) ;-]

Scream and shout and jump for joy! I was here before Kilroy!

Sorry to spoil your little joke. I was here but my computer broke. ---Kilroy