rcihard,

I do not think you. You can use Find Special to only find those cells that have a validation rule, but you would still have to query each cell in the range returned by the find instruction to determine which cells are in error.