In XL 2007, I'm naming ranges using
nm = wks.Name
a = a - 1
rg = wks2.Range(Cells(21, b), Cells(a, b))
wks2.Names.Add _
Name:=nm, _
RefersTo:=rg, _
Visible:=True

I can see them in the Name Manager, but I can not see them in the
Names box (upper left), nor can I reference them as a Data Validation
source or a ListBox source.

What I really want to do is use two ListBoxes, with LB2 taking its
reference from the selection of LB1. I found this from Debra
Dalgleish:

Create a change event for ListBox1, with code similar to the
following:

Private Sub ListBox1_Change()
ListBox2.ListFillRange = ListBox1.Value
End Sub

but I can't get the ListBox I created on the worksheet to accept the
named range as a source!!

Can someone help me make sense of this?

Ed