Hello,

I am assigning all my valid cells a Range ID by setting the Range
Property "ID".

If I add list validation to a cell and change its value using the
validation drop-down, the cell looses its original ID and gets the ID
of Cell which has the value.

Why should both value and ID change for this cell (validated) when list
validation is applied and not only value? Other properties like formats
etc don't get copied over.

Regds
Gap