Hi Hanif,

Thanks if u satisfied with the solution then don't forget to mark this Thread as SOLVED.

Goto 1st Post - Goto Thread Tool - then Select Mark this thread as sloved.

to know how i prepared then open the script page make the window short and press F8 slowly then u will come to know how that code was working.

and one more thing Hanif see how much knowledge i have in excel, macro from that level i was prepared for u and SIR have more and more experience than me if possible follow his steps might b u will get better solution than me. try it.

Thanks - Naveed.