Run macro if cell value changes
 

Use a separate Worksheet Calculate event for the second test.


b.t.w. - consider putting:

Application.EnableEvents = False
and
Application.EnableEvents = True

as an envelope around your code in both tests.
--
Gary's Student
gsnu200712