Hi
see: http://www.contextures.com/xlNames01.html#Dynamic

--
Regards
Frank Kabel
Frankfurt, Germany

"Cecilkumara Fernando" <cekufdo@sltnetDOTlk schrieb im Newsbeitrag
...
Hi All,
This may be a known issue but I came across today.
The named range should be an absolute one for indirect function to
work else
it will produce an error.
Name- Fruits Refers to range=Sheet1!$H$1:$H$20
=Indirect("Fruits") works fine
Name- Fruits Refers to range=Sheet1!H1:H20
=Indirect("Fruits") raise a #value error
Name- Fruits Refers to range=OFFSET(Sheet1!$H$2,0,0,20,1)
=Indirect("Fruits") raise a #ref! error
any work around to get a dynamic range as a list for Data
Validation???

Regards,
Cecil