| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation
created a cell with validation not to accept invalid data. This seems to work
fine within the same sheet. BUT when invalid data is copied from another sheet in the same cell using (Paste Special - values) , validation is not performed. any suggestions |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data validation
Data|validation is not very robust (as you've seen).
Maybe you can copy from the formula bar and paste into the formula bar? Or remove the data|validation and replace it with some kind of worksheet_change event. (Which fails if the user disables macros or events.) aza wrote: created a cell with validation not to accept invalid data. This seems to work fine within the same sheet. BUT when invalid data is copied from another sheet in the same cell using (Paste Special - values) , validation is not performed. any suggestions -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
