Forum Discussion
CopyPicture method of Picture Class failed error
Hello All, I'm facing Run time error 1004 sometime when I run code & sometime code works perfectly. for few user code run but few user face this issue. earlier it was working fine for all. when I ...
HansVogelaar It works well for me but my team member faces issue.
same thing happened earlier as well. sometimes it works fine, not sure what exactly is issue.
As a test, insert the following lines above the CopyPicture line:
Application.CutCopyMode = False
DoEvents
and below it:
DoEvents
I have updated code as per suggestion & its almost working for all member except one or two member 😞
getting error as below with one
Is something wrong in paste action? need to paste in any other way? should I use .pastespecial instead of .paste?
Try adding another DoEvents above ActiveSheet.Paste
HansVogelaar do I need to add it after paste action as well?
with DoEvents above ActiveSheet.Paste still getting paste action error.