Delete picture in VBA

[manwi004]

I have a beautiful workbook that I created with help from this forum, and it would be perfect if I could figure out one last problem. Basically, I want to edit my current macro to delete a picture, and then fill in a new one.

Currently, cell C3 is a manual value cell, where the user enters a product SKU and a bunch of data fills the page. Cell D2 is a VLOOKUP of C3 to another worksheet which contains the relevant product image URL. I have a macro written which navigates to that URL, and populates A2 with the products image. Enter SKU in C3 - get product image in A2. It's pretty slick, but has one problem. Every time the new sku is entered, the new product image is just stacked onto the old ones. If you enter 100 skus, you have 100 images on top of each other. Is there a way to edit the following Macro so that when a new sku is entered, the old image is first deleted, and then a new one is filled in? Current Macro:

Please Login or Register  to view this content.

[royUK]

Duplicate post

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.