ActiveSheet.Pictures.Paste.Select Problem

[Tifa]

Hello!

I Recorded a macro to copy and paste some cells to another row, one of the cells contain a picture, some times the macro work and usually, it gives me 1004 error "Microsoft cannot paste the data"

Range("L2").Select
Selection.Copy
Range("L10").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 0).Range("A1").Select

ActiveSheet.Pictures.Paste.Select


the debugger always shows that the problem is in the last line above "ActiveSheet.Pictures.Paste.Select"

I tried some other pasting codes all give the same problem

how could I fix this please?

 

[mohadin]

ActiveSheet.Pictures.Paste

Is enough

 

[Tifa]

ActiveSheet.Pictures.Paste

Is enough

The problem is that sometimes it works without errors and sometimes or we can say most of the times it gives me 1004 error and the debugger highlights "ActiveSheet.Pictures.Paste.Select Problem"


how could I solve this

 

[mohadin]

Sorry
I've been testing your code several of time with no errors at all

 

[Tifa]

Sorry
I've been testing your code several of time with no errors at all

which version of office are you using, I'm using office 2019, I heard 2016 is more stable but I don't really know is that true or not

 

[Tifa]

which version of office are you using, I'm using office 2019, I heard 2016 is more stable but I don't really know is that true or not

which version of office are you using, I'm using office 2019, I heard 2016 is more stable but I don't really know is that true or not

Sorry, I realized now you are using 2013

the picture I m trying to copy is linked with a formula

 

[Tifa]

Sorry
I've been testing your code several of time with no errors at all

=ProductPic1

the picture is referenced to a name manager ProductPic1:

=INDEX('Data Base'!$R$2:$R$831,MATCH('Data Entry'!$F$2,'Data Base'!$Q$2:$Q$831,0))

 

[Tifa]

I read on Microsoft that some applications can interfere with the VBA code, I started ending background applications I found that the one causing the error is Ditto which is a clipboard application.


now everything is working fine.

Thanks