Is there an image?

M

MD

Hi all,

If in a zone of cells (say a1:e22) contains an imported picture (.jpg), Is
there a way to find out via coding if these cells contain one or more
pictures and if so, print activesheet.

I have a printing routine that prints several pages and I end up printing
the sheet of images but it doesn't always have picture on it.

Regards,

MD
 
T

Tom Ogilvy

for each pic in Activesheet.Pictures
msgbox Pic.TopLeftCell.Address
Next

you could loop through the ranges you want to print and use the intersect
method to see if any of the pictures fall in that range. Note that (oddly
enough), there are more than pictures in the picture collection, but this
should be a start.
 
M

MD

Simple and efficient!!!.... thx Tom

MD


Tom Ogilvy said:
for each pic in Activesheet.Pictures
msgbox Pic.TopLeftCell.Address
Next

you could loop through the ranges you want to print and use the intersect
method to see if any of the pictures fall in that range. Note that (oddly
enough), there are more than pictures in the picture collection, but this
should be a start.
Click to expand...
 
Top