Quick Excel Macro: Remove All Pictures
I pasted some content into Excel, and while I did want the formatting, I didn’t want the pictures it included. This meant I couldn’t use Paste Special.
Solution? A quick macro to remove all shapes from the sheet after I pasted:
Public Sub RemoveAllShapes()
For Each e In Shapes
e.Delete
Next
End Sub
