Fill column with color
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 |
All times are GMT +1. The time now is 05:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com