Ability for Excel to find and replace graphic objects (like Word)

M

Marjan S

When one copies and pastes content from the web, all unusable graphic get
copied over to Excel and it requires to click each one (which may have
overlap or be invisible) to delete one by one. A find and replace all
function for graphics (like Word) would solve this problem.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
A

Anne Troy

Marjan: You might be able to use something like this:
Edit-->Go to-->Special. Choose Objects. Hit your delete key.
I used to do that all the time when copying from eBay and wanting to get rid
of the Star icons.
************
Anne Troy
www.OfficeArticles.com
 
J

John Michl

I've used the following in a VBA module. It wipes out all shapes in
the sheet so be sure that is what you want to do.

- John

Sub RemoveShapes()
For Each sh In ActiveSheet.Shapes
sh.Delete
Next sh
End Sub
 
M

Marjan S

Anne,

This worked! Thank you so much. Great suggestion ... just what i was
looking for. :)

Marjan
~~~~~~~~~~~~~~~~~~~~
 
Top