Question about removing Web formats and content

43N79W · Aug 23, 2004

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-

Tom Ogilvy · Aug 23, 2004

Activesheet.Shapes.SelectAll
Selection.Delete

38N90W · Aug 23, 2004

Once again, thank you Tom!

-gk-

Tom Ogilvy said:
Activesheet.Shapes.SelectAll
Selection.Delete

Question about removing Web formats and content

43N79W

Tom Ogilvy

38N90W