Deleting selected images from Excel worksheet
I want to remove certain images from a spreadsheet. How do I modify
the code to only select and remove the images that appear in cell L43
and not all images on the active sheet?
Public Sub Remove_Images()
DimRange = Application.Cells.Range("L43")
ScreenUpdating = False
ActiveSheet.Pictures.Select
Selection.Delete
Application.ScreenUpdating = True
End Sub
|