I think you are right Ron, I only spotted the A1 twist at the end and added
it without testing.

Your approach is more robust.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ron Rosenfeld" wrote in message
...
On Tue, 3 Jun 2008 12:42:00 +0100, "Bob Phillips"
wrote:

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target

Bob,

In my limited testing, this doesn't work if Me.Range(WS_RANGE) contains a
formula, and the precedent cell is changed.

Is there some efficient method of handling this, rather than firing the
macro
for every change?
--ron