hi NoSparks,

sorry for the late response.. its working but when copy down or copy/paste the worksheet change event is not triggered.

I try to add Application.EnableEvents = False and Application.EnableEvents = True but still nothing happen

thank you very much