Hi again Brad,

I have had another look at your question and now I am wondering if what you
really want is to be able to use the named range in a formula on the
worksheet not in VBA code as per my example. If this is correct, then you
just use the name in lieu of the column reference.

Following example of a VLOOKUP formula with column reference and replacing
column reference with the named range.

=VLOOKUP(A1,$C:$C,1,FALSE)

Replace $C:$C in the formula as follows.

=VLOOKUP(A1,MyDate,1,FALSE)

or if using xl2007 with scoping of named range and referencing from another
worksheet.

=VLOOKUP(A1,TABLES!MyDate,1,FALSE)


--
Regards,

OssieMac