The Pictures Collection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I remove all pictures from a spreadsheet and leave only the data?
 
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)
 
You must log in or register to reply here.

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

Similar Threads

Copying a Picture From Cell Comment 0
imbedded picture 2
insert picture 1
Copy/Paste and remove blanks VBA 0
Store a picture in a cell 3
Request for Help 3
Picture question 6
Spam, disgusting accounts being created!! 5

Back
Top