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/comm...heet.functions

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

"Marjan S" <Marjan (E-Mail Removed)> wrote in message
news:2854D00A-FB1C-4FB9-8886-(E-Mail Removed)...
> 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/comm...heet.functions

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

Anne,

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

Marjan
~~~~~~~~~~~~~~~~~~~~

"Anne Troy" wrote:

> 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
>
> "Marjan S" <Marjan (E-Mail Removed)> wrote in message
> news:2854D00A-FB1C-4FB9-8886-(E-Mail Removed)...
> > 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/comm...heet.functions
>
>
>

Cool beans
************
Anne Troy
www.OfficeArticles.com

"Marjan S" <(E-Mail Removed)> wrote in message
news:3D7E4AAF-CF09-4B80-B66A-(E-Mail Removed)...
> Anne,
>
> This worked! Thank you so much. Great suggestion ... just what i was
> looking for.
>
> Marjan
> ~~~~~~~~~~~~~~~~~~~~
>
> "Anne Troy" wrote:
>
>> 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
>>
>> "Marjan S" <Marjan (E-Mail Removed)> wrote in message
>> news:2854D00A-FB1C-4FB9-8886-(E-Mail Removed)...
>> > 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/comm...heet.functions
>>
>>
>>