Excel How do I delete images in a specific range


Joined
May 4, 2018
Messages
1
Reaction score
1
I have a macro that imports data from a selected file. The data includes some images. The problem I am having is if i have data and images already in my document, and I go to import new data, the images do not delete and simply get pasted on top of each other. I wrote code to select the cells and clear them, but it doesn't clear the images.

I think the solution is to put some code at the beginning that can select the images in the cell range and delete them, before the new data is imported.

I came across a solution that Selects all images in the worksheet and deletes them, But I have other images that I need to keep.

Is is possible to tell it to select all images in a specific range of cells?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top