Prev: vba project password
Next: Setting up a macro that can be ran from any excel file.
From: Pankaj on 29 Apr 2010 15:05
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.

From: Gary''s Student on 29 Apr 2010 15:31
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.
>
From: Peter T on 29 Apr 2010 16:04
PicCount = Activesheet.Pictures.Count

Regards,
Peter T


"Pankaj" <Pankaj(a)discussions.microsoft.com> wrote in message
news:6C24CBA0-0E9D-492D-9641-DE9CF8C90FFC(a)microsoft.com...
>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.
>


 | 
Pages: 1
Prev: vba project password
Next: Setting up a macro that can be ran from any excel file.