I have been using this code for Data Validation for some time, but now when I try to use it, it throws a Run Time Error '1004' Application-Defined or Object-Defined Error. How can I change this to make it work again. I am using Office 365.
.Add Type:=xlValidateList...