I've gotten a little further, just can't quite get my sub to read
named arrays. For instance, this works:

Sub MySub1()
Msgbox Range("MyNamedCell")
End Sub

...but this doesn't:

Sub MySub2()
Dim MyRange as Range
MyRange = Range("MyNamedRange")
End Sub

I get "Run time error 91: Object Variable or With object variable not
set." Debug highlights the 3rd line in my second subroutine.

When I try something simpler:

Sub MySub3()
Dim MyRange as Range
MsgBox Range("MyNamedRange")
End Sub

I get a type mismatch 13. Is there some syntax I need to use to
access a named range of more than one cell?