Logo
Tuesday- May 14th, 2024
 

 

Swift Data Services

 

Have you hugged your data today? I haven't hugged your data either, but I'd like to.

 

Remove Images from Excel Sheet

 

Occasionally data is imported from a webpage and will have extraneous images that will need to be removed.

Here is a short VB script to remove them.

Please note this only works on one page of a spreadsheet at a time.

Sub delPics()

ActiveSheet.Shapes.SelectAll

Selection.DeleteEnd Sub