Count Images in an Excel Sheet

[Pankaj]

I have saved excel sheets with screen prints in it. I need to know if I can
get the total number of screen shots in a particular excel sheet.

 

[Gary''s Student]

Try:

Sub HowMany()
MsgBox ActiveSheet.Shapes.Count
End Sub

 

[Peter T]

PicCount = Activesheet.Pictures.Count

Regards,
Peter T