Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Data Validation - copy paste !

I need to be able to copy paste (special - values) in the range of where my
Data Validaton is, but by doing so it will override the DV.

Is it possible to copy paste in the DV field without destroying the DV
and also notify me if my copy paste violate the DV criteria?


--
Christoffer Bloch Andersen
Trainee
NNE Pharmaplan A/S
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Data Validation - copy paste !

Hey, i tried with paste special, ok it keeps the Data Validation but
it doesnt notify me there is a wrong entry!
How can i check it?
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
Data Validation (copy paste error) Christoffer Bloch Andersen Excel Worksheet Functions 0 February 3rd 09 01:45 PM
Data Validation (copy paste error) Christoffer Bloch Andersen Excel Worksheet Functions 0 January 26th 09 11:53 AM
problem data validation and copy/paste Theo Excel Worksheet Functions 2 January 13th 08 08:30 PM
Copy/Paste over rides data validation jk Setting up and Configuration of Excel 1 July 23rd 06 03:39 AM
Data validation does not seem to work with copy/paste LAF Excel Discussion (Misc queries) 1 September 15th 05 09:31 PM


All times are GMT +1. The time now is 07:35 AM.

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

About Us

"It's about Microsoft Excel"