Named ranges

  • Thread starter Thread starter hshayh0rn
  • Start date Start date
H

hshayh0rn

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?
 
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.
 
Forgive my ignorance, how do I do that? I'm adding the formula to the "refers
to" field within the defines name box.
 
Back
Top