View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 1
Default 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