Hi

I want to use data validation and have been looking at the website
www.contextures.com

From here I have used the following formula in my data validation / source
to link to a list and update automatically as new entires to my list are
added / deleted

=OFFSET(RegionStart,1,0,COUNTA(RegionColumn)-1,1)

The problem is I can still enter values not in the list (there are no
blank spaces when I select the list) and I would like to restrict this so
that only values on the list can be entered

Through help on this forum I have figured the issue is most likely related
to the fact that above formula refers to a named range (eg "RegionStart")
rather than specific cells (eg $A$1). Any idea why this is or other options
for me

thanks
--
Kevin