It's really easy to resolve your issue...
As far as i remember, you can't add validation object if it already exists. You have to remove existing validation to be able to add new.
See:
Validation.Add Method (Excel)[
^]
For further information about
Application defined or object ...
error, please check this:
Application-defined or object-defined error[
^]
Finally, i'd suggest to add error handler to your code. How?
Handle Run-Time Errors in VBA[
^]