Count Images in an Excel Sheet

's Computer Specifications

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.

's Computer Specifications

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.
>

's Computer Specifications

PicCount = Activesheet.Pictures.Count

Regards,
Peter T

"Pankaj" <(E-Mail Removed)> wrote in message
news:6C24CBA0-0E9D-492D-9641-(E-Mail Removed)...
>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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Visual Basic: Get row count of a sheet in Excel	Curious	Microsoft Excel Misc	9	6th Jul 2009 08:43 PM
delete images in an excel sheet	raj.sinha@gmail.com	Microsoft Excel Programming	2	14th Jun 2006 06:51 PM
How to increase max. Row count in an Excel sheet?	Adarsh Sharma	Microsoft Excel Misc	2	28th Apr 2004 06:40 PM
VBA code to insert images in excel sheet	Riya	Microsoft Excel Programming	2	29th Oct 2003 12:22 PM
Insert images in excel sheet using VB	Riya	Microsoft Excel Worksheet Functions	0	29th Oct 2003 05:19 AM