Just to clarify.......

As Bob noted, you can just use =Class_6 as the source if that's the only
range name you have. But, I have a feeling that you do have more (and didn't
tell us!) which is why I suggested the Choose formula. If you do have more
names than the Choose formula can be expanded to handle the other names (up
to 29).

Biff

"Biff" wrote in message
...
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" wrote in message
...
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