removing objects..!
in [General]
|
From: via135 via OfficeKB.com on 15 Mar 2010 11:54 hi all.! i have copied a column of data from a website and pasted it into an excel sheet..! the problem is one of the cell is containing an object, something like a text box may be a "radio button" while copying from the website..! i tried my best to remove that object but could not succeed..! any help, please..! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201003/1
From: Luke M on 15 Mar 2010 12:18 Could you use a short macro like: Sub RemoveShapes For Each sh In ActiveSheet.Shapes sh.Delete Next End Sub -- Best Regards, Luke M "via135 via OfficeKB.com" <u23552(a)uwe> wrote in message news:a50d204c606d2(a)uwe... > hi all.! > > i have copied a column of data from a > website and pasted it into an excel sheet..! > > the problem is one of the cell is containing > an object, something like a text box may be > a "radio button" while copying from the website..! > > i tried my best to remove that object but could not succeed..! > > any help, please..! > > -via135 > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201003/1 >
From: via135 via OfficeKB.com on 15 Mar 2010 13:06 yes..! it works like a charm..! thanks Luke..! -via135 Luke M wrote: >Could you use a short macro like: > >Sub RemoveShapes > For Each sh In ActiveSheet.Shapes > sh.Delete > Next >End Sub >> hi all.! >> >[quoted text clipped - 10 lines] >> >> -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201003/1
|
Pages: 1 Prev: Pivot Table - Group by Date Excel 2007 Next: Extremely slow calculation of lookup formula |