Hello,
Is there a way for excel to know how many rows are left on a sheet when printing. Here is my problem, I have a random number of rows on any given report. I run a macro and I want to include a 2nd report at the bottom of my first list. Unfortunately, sometimes the start of the 2nd report happens right at a page break and it looks really bad. I'd rather have excel know how big my data set is and if it can squeeze on the same page do it, if not insert page break...
Bookmarks