If you have an excel file and there are a lot of overlapping shapes, not beautiful, what will you do. As for me, I will think of some way to delete it so quickly. And in excel, I will think of VBA immediately. Just press one is to solve the problem, reduce the time for bullshit, we have more time to do what we like.
Next I will share the code to remove all shapes in the active Excel sheet.
For Each shape In ActiveSheet.Shapes
The above code is simple, isn’t it?
You just need to press Alt + F11, Insert Module and insert this code to be used. If you don’t know how to create the Module, you can read it at:
Explain the code: You use the For Each Next loop to delete each shape in the active Sheet. When you click the button, all the shapes in that Sheet delete, so you should use it very carefully.
Thank you for reading.