That appears to be the case. I suspect that using INDIRECT causes Excel to
return an Array Constant, which is not valid as a DV source. Whereas,
directly referencing the Dynamic Range Name returns the actual list.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Doug Glancy" wrote in message
...
Am I correct in thinking that I can't do a data validation list, where I
use Indirect to refer to a cell that contains the name of a dynamic range
in another sheet?

Thanks in advance,

Doug