Updating Cells against Validation Parameters

Is there a macro or VBA code that will check current cell contents against the cell validation parameters? The cell can violate the validation parameters in two cases (that I can think of);
1. If the validation parameter is applied when the cells are already populated

2. If you're using the dependent list validation as discussed in "Lists Data Validation Post" (http://www.excelforum.com/showthread.php?t=594442)

I'd like to run code that flags the fact that these cells exist.

Thanks

ChemistB

The VBA below should achieve what you need. It checks all cells that have validation criteria & tests to see if the current data is valid or not, then reports the results as a message (and also selects invalid cells).

Please Login or Register  to view this content.

Wow, this is great. Thanks Loz!

ChemistB