![]() |
How do I prevent a bmp from printing over two pages
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 |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com