View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Removal of cell objects

How about this tiny macro:

Sub picgone()
ActiveSheet.Pictures.Delete
End Sub

it will remove all picture on a sheet.
--
Gary''s Student - gsnu200812


"M" wrote:

Removal of cell objects
How do I remove a picture from multiple cells?
For example : The arrow placed to one side of a cell to indicate the
something about the data the cell contained. Selecting it indicates it is a
"picture" that can be individually formatted or copied or deleted
individually.

BUT: I have not been able to remove it by deleting the column or clearing
the contents of a selected range of cells. For example when I delete a column
of cells containing the offending objects €“ they remain in place, they remain
behind when I move the data the cell originally contained to another column.
Again, I can select each "picture" and delete each individually but would
like to delete these objects from a range of cells.

This has been a continuing "headache"
Thank you
M