I'm trying to write VB code in Excel such when I paste a image in worksheet1 is automatically pastes is to worksheet2 : I would like a user to paste an image into a worksheet and automatically have it pasted to a second worksheet.  I have found some VB code that gets me close, but can't figure out how to finish it.  The image will change from user to user, but I'd like the action to occur as soon as the user pastes the image into E4.

I found this code, which helps, but its is not automatic.

Sub InsertLogo2()
    Dim strPath As String
    Dim shtSheet As Worksheet

    strPath = "C:\GraphicFolder\PictureName.bmp"

    For Each shtSheet In Worksheets
        shtSheet.Activate
        Range("A1").Select
        ActiveSheet.Pictures.Insert (strPath)
    Next shtSheet
    Set shtSheet = Nothing
End Sub

I'm new to VB, so really struggling with this.

Thanks!

