Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Data using Validation Table cell range..... Dermot Excel Discussion (Misc queries) 16 January 5th 10 09:35 PM
Data Validation to range names for Chart Source Data Candyman Charts and Charting in Excel 1 September 3rd 09 07:27 PM
How to optimize? large non-contig cell range for data validation l ker_01 Excel Discussion (Misc queries) 5 May 1st 09 11:05 AM
Can the data validation list range of one cell be driven by theco Ciarán Excel Discussion (Misc queries) 1 February 27th 09 02:10 PM
Data Validation and Name Range Harry Stevens Excel Worksheet Functions 2 May 21st 07 06:59 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"