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
|