ExcelBanter - Count Images in an Excel Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Count Images in an Excel Sheet (https://www.excelbanter.com/excel-programming/442165-count-images-excel-sheet.html)

pankaj

Count Images in an Excel Sheet

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

Count Images in an Excel Sheet

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.

Peter T

Count Images in an Excel Sheet

PicCount = Activesheet.Pictures.Count

Regards,
Peter T

"Pankaj" wrote in message
...
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.

All times are GMT +1. The time now is 08:44 AM.