| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Pictures Collection
How can I remove all pictures from a spreadsheet and leave only the data?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
| Storing Clip Art pictures in My Pictures folder | Excel Discussion (Misc queries) | |||
| Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
| Best template to inventory toy collection w/pictures included | Excel Discussion (Misc queries) | |||
| Collection | Excel Programming | |||
Linear Mode
