• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro hang


New Member
Hi all
My Macro copy picture from one sheet and paste it to another sheet. My code works fine but face issue that it as i press F5, Macro started and hang prompt the error that picture can't be pasted. Then, I press F8 key & Macro resume from the error and after pasting in some rows, prompt the same error. For reference, error snap & code is pasted.
My concern is that Macro should be operate smoothly without prompting error as logically, there is no error and Macro start resume after pressing F8 key for another rows and prompt the error after pasting to some rows. Data in my case is 2048 rows with 8 columns and 2 pictures pasted as per the requirement.