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.
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.