Okay, thnx for clarification Bob
Can u please help me how to run this code or command........I have copied the code u have mentioned and pasted it in a VBA editor.....thn wat to do next??