A very tiny trick:

When you insert the new item in the Validation List, insert it in the middle
rather than the end. This way you avoid re-defining the list range.
--
Gary''s Student - gsnu200823


"NazRem" wrote:

Hi!
How can a drop-down validated cell (data validation) be automaticaly updated
whem i add an item to the original list.