| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing objects..!
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.a...excel/201003/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing objects..!
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@uwe wrote in message news:a50d204c606d2@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.a...excel/201003/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing objects..!
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.a...excel/201003/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
| OLE Objects | Excel Discussion (Misc queries) | |||
| Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
| Imported objects | Excel Discussion (Misc queries) | |||
| VBA Objects | Excel Discussion (Misc queries) | |||
Linear Mode
