removing objects..!

[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

 

[Luke M]

Could you use a short macro like:

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

 

[via135 via OfficeKB.com]

yes..!

it works like a charm..!
thanks Luke..!

-via135

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