Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data validation does not seem to work with copy/paste
I have set up some data validation for each cell within a range. When I manually enter invalid data in one of those cells, the data validation works and an error message pops up. When I copy from one cell with data to another cell, where the data validation results in false, it allows me to paste the value with no error message. Is there any way to fix this? -- LAF ------------------------------------------------------------------------ LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656 View this thread: http://www.excelforum.com/showthread...hreadid=468024 |
#2
|
|||
|
|||
Type "Data Validation" into Excel Help...and click on "troubleshooting data validation"... you'll see: Code: -------------------- Copying, filling, and calculating by formula override my data validation. Data validation is designed to display messages and prevent invalid entries only when users type data directly in a cell. When data is copied, filled, or calculated by a formula, the messages don't appear. -------------------- The help file goes on to list several ways to disable copy/paste to prevent this issue. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468024 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |