Dear Jon,
One workaround could be to check the data which is being entered - in the
light of it's format AND it's value. Validation may behave differently on
formats / on values. For example, a Date entered as a Date or entered as a
value.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(H
hi Jon,
This has always been a problem with data validation and paste.
The only way around it, that I know of, is to use a 'Change' event macro.
You ask VBA to examin any new data to see if it is suitable. If it isn't, get
VBA to delete the entry, and post a message box politely informing the use
