Just make sure your dynamic range is a workbook range, not a worksheet range,
or you won't be able to use it with DataValidation.

"hshayh0rn" wrote:

I have a name range of cells on a seperate worksheet in a workbook. I need
the range to dynamically change size so that only users can add values to the
column or remove values from the column and the choicelist will still contain
all values. The choice list dropdown is on sheet1 and the values are in a
named range on sheet3. suggestions on how to do this?