Data validation - How to get Invalid cells - VBA

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

Ollie,

thanks for the special cells tip

Please Login or Register  to view this content.

just processing cells with validation has helped allot.

Cheers