OK after continuing to guess and have a go I came up with something that works:
Sub Insert_Sig()
If Worksheets("PLAN").Range("L3").Value = "HIGGINS" Then
Worksheets("Raw Data").Shapes("higgins").Copy
Worksheets("PLAN").Range("P3").PasteSpecial
End If
If Worksheets("PLAN").Range("L3").Value = "PERRIN" Then
Worksheets("Raw Data").Shapes("perrin").Copy
Worksheets("PLAN").Range("P3").PasteSpecial
End If
End Sub
However when a new name is selected and the macro re-run all it does is paste over the old picture. How can I delete a picture (if one exists) and then run the "IF" checks and paste the new correct picture?
(I need code that translate between excel 2003 and 2007).
Bookmarks