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-