Selecting pictures within highlighted cells

[FluxxyDub]

Hi,

I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes.

The sort of thing I’m after is:

Range(ActiveCell.Offset(0,0),ActiveCell.Offset(5,5)).Select
ActiveSheet.Pictures.Select
Selection.Delete

But this either doesn’t work or highlights and deletes every picture on the Worksheet, however I only require the single picture to be removed from within the highlighted cell range.

Please help!

 

[johnny51981]

Will the picture that you need to delete vary or will it always be the same one?

 

[FluxxyDub]

Will the picture that you need to delete vary or will it always be the same one?

Thanks for your reply. It'll always be a different picture. It's basically being pushed from a different macro to populate but I'm trying to make another macro in reverse in case someone makes a mistake.