Right-click on your Worksheets's tab (down left)
Select View code
This will open a new window, where you paste my code.

If you're stuck, please post back!

HTH
--
AP

"daidipya" a écrit dans le message de news:
...
Thanks for the expeditious reply.

but i do not know anything about the vba so i have not understood
where to paste the above said code.