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