when I copy the table as picture, another one is creating from the same table, using VBA macro

[Sna]

guys i made a macro in excel i want to copy the table when i run this macro the table area duplicating itself please help me, thanks

Sub screenshot()
Dim w As Worksheet
    Range("D1:F7").Select
    Selection.Copy
    Range("C4").Select
    ActiveSheet.Pictures.Paste.Select 'when i remove this it wont recreate the table but now my clipboard is getting empty

    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = ""
    
End Sub

 

[Alex Blakenburg]

What are you trying to do ?
Currently it is creating a picture of the table which is exactly what that code is intended to do and which your heading indicates that you want.

 

[Sna]

What are you trying to do ?
Currently it is creating a picture of the table which is exactly what that code is intended to do and which your heading indicates that you want.

Private Sub CommandButton1_Click()
Call screenshot
last = Cells(Rows.Count, "A").End(3).Row
Selection.Copy


ActiveWorkbook.FollowHyperlink Address:=" https://web.whatsapp.com/send?phone=" & Cells(2, 1) & "&text=" & Cells(2, 2)

Application.Wait Now + TimeValue("00:00:20")

Call SendKeys("^v")

Application.Wait Now + TimeValue("00:00:07")

Call SendKeys("{ENTER}", True)
Application.Wait Now + TimeValue("00:00:07")


Call SendKeys("{ENTER}", True)
SendKeys String:="^w{enter}", Wait:=True
Application.Wait Now + TimeValue("00:00:07")

End Sub

i made a macro when i click the button it will automatically send it to whatsapp it calls "screenshot" there but the problem is when i call this screenshot thing it creates the table inside the project like this
this one is normal but when i call this script it became like this, so i dont want it do paste the picture to the tables like in second photo

 

[Alex Blakenburg]

You might be better off starting to new thread making it clear that you are trying copy either the table or a picture of the table (clarify which one) into a WhatsApp message.
Provide all the code you have above.
I can't help you with that.