So I have a spreadsheet I've extracted, and it has two columns of images in it (which I don't want):
Ok, so I'll just delete the columns like I would with any other data, right?
Hm. That didn't work. Are you really telling me that I have to select and delete these one-by-one? NO WAY!
Thankfully, there's a quick macro you can run to get rid of all images in a worksheet like this:
Dim s As Shape
For Each s In ActiveSheet.Shapes
s.Delete
Next
Running this will remove all these pesky images in one shot. No fuss, no muss.
Happy deleting!
No comments:
Post a Comment