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

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

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