VBA to have msg box appear if range >x

[maximus0120]

Hi guys, Im looking to have a code that will display a message box when any cell in a range of cells, is greater than another cell i select. For example, if any cell in s2:s730 is greater than cell v2.

[Mordred]

This should do it:

Please Login or Register  to view this content.

[maximus0120]

Thanks alot, it worked great

[Mordred]

No problem maximus