Question about removing Web formats and content
 

I have a nifty little macro that removes MOST of the Web formats and content
when I past Web stuff directly into Excel. How would I go about removing
all the pictures and controls?

TIA.

-gk-

--
=================================================
The creative act is not the province of remote oracles or rarefied geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-

Question about removing Web formats and content
 

Activesheet.Shapes.SelectAll
Selection.Delete

--
Regards,
Tom Ogilvy

"43N79W" wrote in message
...
I have a nifty little macro that removes MOST of the Web formats and
content
when I past Web stuff directly into Excel. How would I go about removing
all the pictures and controls?

TIA.

-gk-

--
=================================================
The creative act is not the province of remote oracles or rarefied
geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-

Question about removing Web formats and content
 

Once again, thank you Tom!

-gk-

"Tom Ogilvy" wrote in message
...
Activesheet.Shapes.SelectAll
Selection.Delete

--
Regards,
Tom Ogilvy

"43N79W" wrote in message
...
I have a nifty little macro that removes MOST of the Web formats and
content
when I past Web stuff directly into Excel. How would I go about
removing
all the pictures and controls?

TIA.

-gk-

--
=================================================
The creative act is not the province of remote oracles or rarefied
geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-