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
y informing the user
that they've done it wrong.
Regards - Dave.
> Date: Fri, 18 Dec 2009 10:11:44 -0800
> Subject: $$Excel-Macros$$ No Data Validation when using Paste Values
> From: jon.wester...@gmail.com
> To: excel-macros@googlegroups.com
>
> I have a spreadsheet with
I have a spreadsheet with multiple data validations that I want users
to paste values to. Unfortunately, I've noted that the data
validation rules don't apply when you paste values.
Do anyone know a work around? Thanks.
--
---
