| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic: Get row count of a sheet in Excel | Excel Discussion (Misc queries) | |||
| how do i sort a data sheet which has images in it also? | Excel Discussion (Misc queries) | |||
| for i...next i over images in a sheet | Excel Programming | |||
| delete images in an excel sheet | Excel Programming | |||
| VBA code to insert images in excel sheet | Excel Programming | |||
Linear Mode
