but you'll need to help Excel I think to figure out which rows are blank.
presumably you want the entire sheet to have NO blank rows in - not even to separate titles and a table or anything?
Is the spreadsheet a single table or lots of distinct data spread out? If a single table you could (with or without a macro) do an autofilter and filter out blanks based on a particular column then print. This could be enabled, print then disabled in a macro.
If it is lots of spread out data the macro would need to analyse each row and either check say the first cell is empty or if you have lines that have something on them but the first cell is empty that wouldn't work! Excel has trouble knowing what is empty and what isn't and you will have to define that somehow.
Let me know your thoughts on this and I can help further.