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.
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 Sub
hi Juliano-Petrukio , im not sure how to do it? where u i add the command?