that's a step closer, but I still don't have the 'named range'
configured properly yet.

at the end of your code, I added the following to create the named
range:


Code:
--------------------
ActiveWorkbook.Names.Add Name:="mynamedrange", RefersTo:=myarray
--------------------
where 'myarray' is the array created by the macro.

if i then look at the newly created named range via Insert|Name|Define
in Excel, then I get as a formula what looks like the classical array
syntax, complete with brackets { }...


Code:
--------------------
={"Sheet1";"Sheet2";"Sheet3"}
--------------------
Problem is that it won't work as an argument for the data validation
list source. How do I un-array it?