paste photos with macro error 1004

[AHMADIT986]

hi everyone

when I use macro for copy and paste photo in excel 2013 I received error 1004
i click debug and just click F5 without any change ,after that macro complete command.
what should I do to avoid this problem

Sub Tester()    Sheets("STATS").Select
    Range("B223:K244").Copy
    Sheets("photos").Select
    Range("b223").Select
    ActiveSheet.Pictures.Paste Link:=True
    Application.CutCopyMode = False
End Sub

 

[Worf]

Hello and welcome to the Board

This executed well from the VBE and also from the sheet’s macro dialog box:

Sub Tester()
    Sheets("STATS").Activate
    Range("B22:K29").Copy
    Sheets("photos").Activate
    Range("b22").Activate
    ActiveSheet.Pictures.Paste Link:=1
    Application.CutCopyMode = False
End Sub

 

[AHMADIT986]

Hello and welcome to the Board

This executed well from the VBE and also from the sheet’s macro dialog box:

Sub Tester()
    Sheets("STATS").Activate
    Range("B22:K29").Copy
    Sheets("photos").Activate
    Range("b22").Activate
    ActiveSheet.Pictures.Paste Link:=1
    Application.CutCopyMode = False
End Sub

Thank you very much

 

[Worf]

You are welcome