Hi
it would be easy to change this code (to also deal with
ranges). Just post you complete code :-)

-----Original Message-----
Frank Kabel wrote:
[b]Hi
normally the chnage event should be triggered in this
case. you may loop through the range 'target' in this
case.[color=blue]

could you post your existing code?



I think the change event is only when one cell is
changed. There's
even an IF statement in the original code I adapted from
that exits
when target 1 :(

Here's a link to the code:
http://pwei.org/dn/vba.txt


---
Message posted from http://www.ExcelForum.com/

.