Paste Special throwing error first time

I have the following snippet where I am trying to copy a range from a different sheet to a new sheet.The first time when i run this sub,it throws out the 1004 error stating that paste special method failed.But the next time i run the same using a button it works.Any solutionto this is appreciated.(The commented ones are the things i tried)

Please Login or Register  to view this content.

@sid_misra, please remember to use CODE tags around your VBA at all times (per Forum Rules).

Given first post etc I've modified for you ... for more info on tags etc see: here