I don't think so. But you could just have your sub exit if the change isn't in
the range you want:

I start a lot of my worksheet_change procedures with lines like this:

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



Erik wrote:

Is it possible to trigger a Private sub worksheet change for one range and not another in the same worksheet?
Erik

--

Dave Peterson