Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation to range names for Chart Source Data | Charts and Charting in Excel | |||
How to optimize? large non-contig cell range for data validation l | Excel Discussion (Misc queries) | |||
Can the data validation list range of one cell be driven by theco | Excel Discussion (Misc queries) | |||
Data Validation and Name Range | Excel Worksheet Functions |