I need to be able to add and remove data validation from a
particular dropdown list I have in my spreadsheet. Help
suggests something like the following:

With Range("C2").validate
.Add xlValidateList, xlValidAlertStop, "$Z$2:$Z$9"
.IgnoreBlank = True
.InCellDropdown = True
.InputMessage = "Select a Container"
.ErrorTitle = "Invalid Container"
.ErrorMessage = "You have entered an invalid data."
End With

When I try to run this I get Runtime error 438, object
does not support this property or method. What is my
problem.

Thanks in advance!

Kevin