I would like to be able to iterate / process all invalid cells in worksheet.

By invalid I mean Cell(x,y).Validation.Value <> true


I know I can iterate through every cell in every row to find them, but this is toooo slow.


Does any of you clever guys know of a way of referencing just the invalid cells ?


Thanks