Print if there is a picture

[MD]

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

 

[Tom Ogilvy]

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.

 

[MD]

that's it.... thanks Tom

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.