Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK, this gets kind of complicated.
I wrote a macro. The (printing) result can be anywhere from 1 to 4 pages. I really have no way of knowing, in advance, how many pages it will be because there are so many variables. Anyway ... when the macro is finished running, the very last step is that the macro perfoms an "Insert Picture From File" after the last line of data. (The picture is a bitmap but I can make it a jpg or whatever ... I created it from Visio.) The problem is that, sometimes, the bitmap prints ("bleeds") over two pages ... in other words, part of the bitmap prints at the end (bottom) of page two, for example, and continues at the top of page three (or it starts at the bottom of page one and continues at the top of page two). I need to make sure that the entire bitmap prints altogether on the same page. So, how do I say, in a macro: "if there's not enough room to print the entire bitmap at the bottom of page one (or two or three) , then position it (insert it/move it down) so that it prints, entirely, at the top of the next page? Thanks. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
How to I prevent a row from breaking across pages? ... | Excel Discussion (Misc queries) | |||
How to prevent extra blank pages from printing? | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
How to I prevent a row from breaking across pages? | Excel Discussion (Misc queries) |