Picture will intermittently not paste

Asked Jun 09 '20 at 18:57

Active Jun 09 '20 at 19:11

Viewed 128 times

I'm getting an intermittent error (1004 Microsoft Excel cannot paste the data) upon trying to paste an image in Excel as part of a larger VBA code. It's strange because it's only happening some of the time and I haven't been able to identify why. The error handling is also not working, the code is breaking on the paste line.

picTab.range("imageRNG").Copy

On Error GoTo picProblem:  
     picTab.Pictures.Paste  
On Error GoTo 0

edited Jun 09 '20 at 19:11

BigBen

46,229
7
24
40

asked Jun 09 '20 at 18:57

ELW

Can't you just use [`Range.CopyPicture`](https://learn.microsoft.com/en-us/office/vba/api/excel.range.copypicture)? – BigBen Jun 09 '20 at 19:11
The same thing is happening with range.copypicture - intermittently breaking on paste. – ELW Jun 09 '20 at 19:23
I'm guessing a clipboard issue. – BigBen Jun 09 '20 at 19:28
Thanks. Any idea how to fix or identify the issue if it's with the clipboard? – ELW Jun 09 '20 at 19:33
https://stackoverflow.com/questions/60063795/run-time-error-1004-microsoft-excel-cannot-paste-the-data/60065424#60065424 – Tim Williams Jun 09 '20 at 20:20
I also have same issue, finally i found the solution from this https://stackoverflow.com/a/40595546/900284 – Frank Myat Thu Nov 25 '21 at 09:32

Picture will intermittently not paste

0 Answers0