SuperJas,
If you've named the two ranges, it appears that you have, you
should be able to use the
Range(RNGNAMEHERE).address along with the Target.address to see if user
has made a change in the wrong cell.
I use this method often. The only problem that I have is if the
actual range is merged with other cells. However, it isn't that much of
a problem either.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!