Hey all,

I have a document which will require signatures after printed and want to keep the signature portion at the bottom of the page (currently rows 102-104). The problem is that the document will not need to be that long for every person and was wondering if it would be possible to have a macro that checks (C7:C:100), stops printing when it reaches the blank cells, and then prints those last 2 rows?

The goal is to design a mileage log for company vehicles which employees will have to sign and submit at end of month. Obviously, not every employee will be driving the same amount so some will require fewer rows than others, and in the interest of not having extra pages print out I was hoping this print macro could be done.

Thanks for any help.