Is there a way to programmatically in vba delete all the picture on a worksheet in excel?
I have a picture on an excel sheet that i put on and size with a macro. The problem is that i need to put a different picture on when i run the macro again and i need to delete the old picture using vba. I tried recording a macro but it refers to the picture number like "Picture 3" and this number changes so it won't always be picture 3 when i cut and paste it several times. Anyway, is there code to delete all the picture and make the sheet blank? i can't just delete the sheet and create a new one because the sheet is linked to a slide in powerpoint. thank you for the help.