I have a related question about this.

How do you return, in VBA, a value to state whether Data Validation is in effect on a specified range?

I can't find a way to programatically test whether a Validation object exists on a Range. Instead, the only way is to try and read a Validation property and see if it returns the error "Object doesn't support this property or method". This is no good for operating on a Validation property if it exists but skip that code if it doesn't.

Even using On Error Goto ... doesn't trap this error.

I've tried looking for a 'HasValidation' type of property but nothing seems to exist.

I've also tried using xlSpecialCells(xlAllDataValidation) but all this does is return all cells in the same column as the specified Range - because it treats 'no validation' as a validation - even though there is no Validation Object!!!