Hmmm ... I'm think this involves the Caller property, which can somehow
be used to return the address of the cell whose editing triggered the
macro.

If I had that, then that could serve as Range("rg1") in the example
you've given
and it would work perfectly.

Thanks very much, Jim.


--
Chief Wiggums
------------------------------------------------------------------------
Chief Wiggums's Profile: http://www.excelforum.com/member.php...o&userid=16934
View this thread: http://www.excelforum.com/showthread...hreadid=516531