Hi Gap,

I replicate half your problem!
If I set a DV list cell ID to some text, then change the cell value from the
dropdown list, the ID is now totally empty. Ie nothing, not same as you -
the new changed cell value.

It does seem odd. Even if there is a fix bear in mind the cell ID is lost
when you save close re-open the file.

Regards,
Peter T

"Gap" wrote in message
oups.com...
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