Print if there is a picture
 

Hi all,

I'd like to know how to code this...

If a range (say a1:z100) has any pictures in it, then print the page else
don't print anything.

Thx for your help

MD

Print if there is a picture
 

If there would only be pictures and they would be in that range if they
exist, then

if activesheet.shapes.count 0 then
activesheet.printout
End If

If not then you would need to be more specific about what could be where.
--
Regards,
Tom Ogilvy


"MD" wrote in message
. ..
Hi all,

I'd like to know how to code this...

If a range (say a1:z100) has any pictures in it, then print the page else
don't print anything.

Thx for your help

MD

Print if there is a picture
 

that's it.... thanks Tom



"Tom Ogilvy" wrote in message
...
If there would only be pictures and they would be in that range if they
exist, then

if activesheet.shapes.count 0 then
activesheet.printout
End If

If not then you would need to be more specific about what could be where.
--
Regards,
Tom Ogilvy


"MD" wrote in message
. ..
Hi all,

I'd like to know how to code this...

If a range (say a1:z100) has any pictures in it, then print the page else
don't print anything.

Thx for your help

MD