I am not too smart I guess, for I can't seem to find out how to refer
to (read) a named range when the specific work sheet is not known. (I
want to do this in VBS.)

I figured this out all on my own:

set rng = Workbook.Worksheets(1).Range("Name")

But what about when you know "Name" but not what sheet it is in?