This did in fact do what I wanted it to do. Thanks Jim!

"Jim Thomlinson" wrote:

Have you tried

Application.Undo

To undo the changes...
--
HTH...

Jim Thomlinson


"Guy Normandeau" wrote:

I'm in the process of creating a validation function using the change event.
Is there a way that I can use VBA to revert the value in a cell or group of
cells the their original values if I find that the validation failed?