Hi John,

i tried and its working perfect.could you please tell me what are the coordinates i need to change to change the number of columns to copy. And i need to paste special only the values in the destination and what is the code to be edited to do so. Could you please help regarding this?