Thanks for feedback but I really need the indirect function. I know I
can use =Class_6 etc but E11 will be changing, as it is a drop down
list. It may be Class_5, Class_6, Class_12 etc so the data validation
has to pick up the named range which this indicates. If it was not a
dynamic range it works fine, I just do =E11 and whatever value appears
in cell E11 the appropriate named range will appear as the drop down
list, but NOT when it is a dynamic range.
Sorry to be a pain but I really need it to do this.

Graham

Biff wrote:
> Hi!
>
> Do you enter more than just "Class_6" into B11?
>
> Try this as the source for the drop down:
>
> =CHOOSE(1,Class_6)
>
> Biff
>
> "Graham Haughs" <gmh54@supanet.com> wrote in message
> news:O87WysmtGHA.2172@TK2MSFTNGP05.phx.gbl...
>
>>I have a named dynamic range Class_6 which holds the dynamic range
>>=OFFSET(Data!$F$2,0,0,COUNTA(Data!$F:$F),1)
>>I create a data validation list and put the location as =INDIRECT(B11)
>>In cell B11 is the value Class_6
>>When I try to enter =indirect(B11) in the data validation I get the
>>message "The source currently evaluates to an error"
>>I can get the indirect to work with a named list but not with a dynamic
>>range list. Am I doing something wrong or will it not do this. I value any
>>help.
>>
>>Kind regards,
>>Graham Haughs
>>Turriff
>>Scotland
>
>
>