It's not at all clear to me what problem you are having with your code,
but beyond that, Excel does have a Worksheet_Change event that includes
a parameter that is the range (cell) that changed. You could test to
see if a particular named range has the same address as the Target range
and run code if it is...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112280