Excelmasters
Board Regular
- Joined
- Jun 11, 2015
- Messages
- 115
Hello All,
Mrexcel has been always helpful for me whenever i am stuck.
Am going through a strange behavior in my code.
Below is my code
Basically the above code works well, it is copying some pictures from one sheet and pasting into other sheets beside the chart into cells.
The above macro works well in a machine for one user but the same macro throws error (paste method of worksheet class failed and shows error at the code pa.Paste Destination:=pa.Cells(i + rtr1, rtr) ) in the same machine for different user login. neither its system issue nor user issue .. can you please help if someone has already come across these kind of issues and fixed. it would be really helpful if someone helps me on this. thanks.
Mrexcel has been always helpful for me whenever i am stuck.
Am going through a strange behavior in my code.
Below is my code
Code:
For i = Starta To Enda For j = 3 To BL.Cells(Rows.Count, 2).End(xlUp).Row
If pa.Cells(i, Cola) = BL.Cells(j, 2) Then
BL.Cells(j, 3).CopyPicture xlScreen, xlBitmap
pa.Paste Destination:=pa.Cells(i + rtr1, rtr)
End If
Next
Next
Basically the above code works well, it is copying some pictures from one sheet and pasting into other sheets beside the chart into cells.
The above macro works well in a machine for one user but the same macro throws error (paste method of worksheet class failed and shows error at the code pa.Paste Destination:=pa.Cells(i + rtr1, rtr) ) in the same machine for different user login. neither its system issue nor user issue .. can you please help if someone has already come across these kind of issues and fixed. it would be really helpful if someone helps me on this. thanks.