ExcelBanter - The Pictures Collection

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - The Pictures Collection (https://www.excelbanter.com/excel-programming/324845-pictures-collection.html)

TEB2

The Pictures Collection

How can I remove all pictures from a spreadsheet and leave only the data?

Bob Phillips[_6_]

The Pictures Collection

Something like

Dim shp As Shape

For Each shp In ActiveSheet.Shapes
If shp.Type = msoPicture Then
shp.Delete
End If
Next shp

--

HTH

RP
(remove nothere from the email address if mailing direct)

"TEB2" wrote in message
...
How can I remove all pictures from a spreadsheet and leave only the data?

All times are GMT +1. The time now is 11:39 PM.