Macro not working properly when called from Button (Running otherwise)

I have a macro which was running from a long time. Suddenly it stopped working. Upon digging I found out that the macro is not running properly only when it is called from the button. If I try the macro through F8 or Developer Tab everything seems to work fine.

The exact issue is that when called from button the code which is supposed to copy an entire sheet from one workbook to another sheet of a different workbook is pasting the content from below cell instead of A1. As a result excel is not able to paste.

This is only happening when called from button.Has anyone faced this issue.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

The error is happening at the last two lines.

Originally Posted by AnimeshRoy

The error is happening at the last two lines.

What is the error, exactly? Errors do not happen on two lines, they happen on one line. Which line causes the error?

I don't think this is your problem but the code that I would use for those lines is

Please Login or Register  to view this content.