Cannot paste the data error for specific login

[Excelmasters]

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

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.

 

[Excelmasters]

Thread closed.

after lot of research i have found the way which i had to make the sleep of 500 milliseconds inside the loop to properly copy and paste.