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
|