Ability for Excel to find and replace graphic objects (like Word)
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...et.f unctions |
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 wrote in message ... 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...et.f unctions |
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 |
Cool beans :)
************ Anne Troy www.OfficeArticles.com "Marjan S" wrote in message ... 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 wrote in message ... 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...et.f unctions |
All times are GMT +1. The time now is 11:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com