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