Hi,

Is there code I can use instead of an entry in a cell to archive the
following.

I have a drop down list in a cell that is created from the menu item Data,
Validation.... and refers to a named range, this range name is defined with
a formula that varies on what text is in a particular cell, the formula is:
=IF(Menu!$A$1="Adm",Codes!$C$1:$C$30,Codes!$B$1:$B $20). When Adm is in cell
A1 my named range refers to Codes!$C$1:$C$30 whereas is A1 is anything else,
the name range refers to Codes!$B$1:$B$20.

Thanks,

Rob