| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete cell formats but not the content... | Excel Discussion (Misc queries) | |||
| Best solution for removing duplicate content with conditions? | Excel Discussion (Misc queries) | |||
| removing dupliates from 2 lists with similar content | New Users to Excel | |||
| Excel should merge cells without removing content of any cell | Excel Discussion (Misc queries) | |||
| Reference cell formats + content | Excel Discussion (Misc queries) | |||
Linear Mode
