(I thought that I posted this last night but, for whatever reason, it doesn't
appear in the discussion group. So, I'm posting it, again. Sorry if this is
a duplicate.)

At the very end of my macro, I "Insert Picture From File." The bitmap is
"inserted" at the end (after the last row) of my data. The problem is that
the data can end on practically any Row (my results vary all the time) and,
when the spreadsheet is printed, the printout can be anywhere from 1 to 4
pages. So when I insert the bitmap, half the bitmap might print at the
bottom of page two and then the rest of it prints at the top of page three.
(or it bleeds over pages 1 and 2 or pages 3 and 4, again depending upon how
much data there is). I need to make sure that the whole bitmap is printed
together on the same page.

So, how can I "tell" the macro to insert the bitmap at the top of the next
page if (and only if) it won't totally fit on the previous page?

FYI, I'm not sure how often my macro executes the following (partial)
command but it does exist in the macro so I'm listing it here, just in case
it matters (this sets the page length to 74 lines, I think?):
i = Val(lrow) / 74

Thanks. Dan

(I'm a salesman, not a programmer.)