View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gap Gap is offline
external usenet poster
 
Posts: 15
Default Data Validation in Cell changes Range ID?

Hi Peter,

Yes, I am aware that ID's don't get persisted along with the file.

ID will become empty if the source Cell has no ID assigned to it else
it will get the ID of the Source Range even if its a string.

If you Type in the value it behaves correctly. The moment you select
from the drop-down it looses the original ID and gets the ID of the
source cell.( Blank if it was'nt assigned one. Atleast thats what I see
in Excel 2003)

The behaviour is strange though, since the range object itself does not
change. Its not consistent since only its "Value" property should
change not others.

Regds
Gap