Try:

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


--
Gary''s Student - gsnu201001


"Pankaj" wrote:

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.