Hi Greg,

Thanks a ton for the reply!!! I tried the code and it is working preet
fine for me,

I just had one question, can we have a system whete the names are i
sheet2 and the pasting happens in sheet 1 (in the cells a to c)?


Thanks a million for your help!!!!

Paritos

--
Message posted from http://www.ExcelForum.com