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

could you post your existing code?



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

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

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