Near the top of your code:

if target.cells.count 1 then exit sub
if intersect(target,me.range("b99")) is nothing then exit sub

And remember to turn off events if you're changing something (and don't want
that to cause the event to run again).

MikeZz wrote:

I want to run some code whenever someone changes a value in a particular cell
or range. I know how to do it on Worksheet_Change but don't want to have it
actually run code (slowing response down) every time any cell changes.

Is there a way to do this?

Thanks,
MikeZz

--

Dave Peterson