Forum Discussion
Solved
how to delete the object
i need to delete the unknown object from my excel but i cant find the solution
You may try F5 on any empty cells, here Special and Objects, Ok
If delete all objects just press Del after that.
5 Replies
You may try F5 on any empty cells, here Special and Objects, Ok
If delete all objects just press Del after that.
hiSergeiBaklan thank you so so much!!! its worked!!! thank you!!!
izahatta , you are welcome, glad to help
Sub DeleteAllObjects() Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type <> msoChart And shp.Type <> msoComment Then shp.Delete Next shp End Subhi Juliano-Petrukio , im not sure how to do it? where u i add the command?
