| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Validation Error Not Working On Paste Special Values
Hi,
I have data validation that does not permit text to be written in the cell (Basically Text Length = 0). The range of cells with this validation was renamed "ValidationRange". A macro was created so you cannot paste over the data validation and erase it (http://www.j-walk.com/ss/excel/tips/tip98.htm). However, it does not work if someone Pastes Special Values. Can someone help me with a VBA code to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Data Validation to execute when using Paste Special... Val | Excel Programming | |||
| Special Paste Error...Data pastes into one column | Excel Discussion (Misc queries) | |||
| Data Validation - Copypaste special problem | Excel Discussion (Misc queries) | |||
| Copy and paste special, values not working | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Threaded Mode
