Update A Url Image

[SEAN DI''''ANNO]

Dim URL As String
URL = Worksheets("Sheet1").Range("B4").Value
Range("C5").Select
ActiveSheet.Pictures.Insert(URL).Select

Morning, I found the above code on this forum and it works great but I
wonder if it can be modifed. I have a spreadhsheet which asks for a Product
code, when entered another cell changes (using a vlookup) be the URL image of
the product. Using the above code, it displays the URL image which is great.
However, when the product code is changes again, it just inserts another
picture rather than update the existing one. How can I have an object set to
the URL reference so that it can updated everytime the product code is
changed.

 

[SEAN DI''''ANNO]

...Which is my problem Charlotte. if the product No is changed several
times, a new picture is inserted each time with a new name so I was unsure
how to delete teh existing one if there is one. I was trying to have a
picture object already and then just update its URL property but don't know
how to do this. Can you help?

 

[SEAN DI''''ANNO]

Thats great Charlotte and answers my original question. Just one more
question if I may. How do I insert the picture object in a specific position?

 

[SEAN DI''''ANNO]

Thanks Charlotte...Perfect...That was my turn to be stupid.