Getting runtime error 1004 PasteSpecial method of Range class failed

[gamenano]

Hi Guys,

I am getting a strange bug. For some reason, it will only succeed on the alternative attempt. If it runs successfully the first time, the second time will have the 1004 error. If I get the error the first time, I can just end the debug message pop up without touching any code then run it again and it will work. I can't get my head around it....... Please help, thanks!

Please Login or Register  to view this content.

[davesexcel]

What line errors?
It would help if you supplied a sample wb for testing.