In article .com,
says...
Hi Tushar

I want all this process to be done programmatically...hope you
understand...

Yes, and I told you how to get XL to generate the code for you!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions