| 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 |
| 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 | |||
Threaded Mode
