I have a lot of photos in my Excel sheet.
I want to delete them all - currently Ctrl-A just select all cells.
How can I select all photo objects?
I find a quick step as below, refered from this post
We are done.
selection.deleteand hit enter
You cannot quickly select all floating pictures in an Excel sheet.
But you can do a workaround.
TRY BELOW MY FIRST MACRO
Sub DELETE_all_PICS() On Error GoTo booboo For Each Worksheet In ActiveWorkbook.Worksheets Worksheet.Pictures.Delete Next Exit Sub booboo: MsgBox "There is A problem." End Sub