removing objects..!

  • Thread starter via135 via OfficeKB.com
  • Start date
V

via135 via OfficeKB.com

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
 
L

Luke M

Could you use a short macro like:

Sub RemoveShapes
For Each sh In ActiveSheet.Shapes
sh.Delete
Next
End Sub
 
Top