| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use VLOOKUP TO PRINT A PICTURE | Excel Discussion (Misc queries) | |||
| Print Hyplink Picture | Excel Worksheet Functions | |||
| picture distorted after print | Excel Discussion (Misc queries) | |||
| I can print my Header Picture!! =( | Excel Discussion (Misc queries) | |||
| Print Picture in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
