Consider defining the Validation range by means of a Dynamic Named Range - see link in sig. for more info.

If needed post a sample file.