Application.EnableEvents is very important ... setting this made m
can skip the looping...

thanx...

but this function very dangerous...once setting error it may cause th
excel cannot be closed normally.... must use CTRL+ALT+DEL

:

--
tpk103
-----------------------------------------------------------------------
tpk1031's Profile: http://www.excelforum.com/member.php...fo&userid=1446
View this thread: http://www.excelforum.com/showthread.php?threadid=26151