Can someone point me in the right direction? I need to perform the the
equivalent of the following steps using VBA code instead of manual entry.

Create a Reference to the Source List
1.. Open the workbook in which you wish to use the list in Data
Validation.
2.. Choose Insert>Name>Define
3.. Type a name for the List, e.g. MyList
4.. In the refers to box, type a reference to the named range. Start with
an equal sign, then the workbook name and an exclamation mark, followed by
the range name, e.g. =DataValWb.xls!CustName
5.. Click OK
Thanks,

Keith