Removing pictures from spreadsheet with VBA

[Scott Huish]

I have a spreadsheet where data is copied from the web and pasted into a spreadsheet. However pictures are part of this data, and I want to get rid of them with VBA leaving everything else. How can I do this? The number of pictures can vary every time.

 

[VoG]

Try this

Sub nopics()
ActiveSheet.Pictures.Delete
End Sub

 

[Scott Huish]

Absolutely beautiful! I put that in a Worksheet Change event and as soon as the data is pasted in the pictures go away.

Thanks!