Event macro

A

Amy

Hi Bigwheel,

The macro has a problem, the message is popping up when
any value is placed in any cell on the worksheet.

Can it activate only if values in the range of cells is
changed?

Thanks
 
F

Frank Kabel

Hi
use a statement like
if intersect(target,me.range("A1:B202")) is nothing then exit sub

at the beginning
 
Top