Hi Adam
Are you able to post some sample data?
My initial thoughts would be:
A macro to either set the print range (perhaps using a Dynamic Named Range as the source) or temporarily hide the empty cells.
The macro could be a Workbook_BeforePrint and would fire when Print is pressed.
Again, without having seen your spreadsheet, this might work (If your range needed is in cell A1 on Sheet1):
This should be entered in to the Worksheet macros in the VBE Editor (i.e. not in a Module or Sheet).
If this doesn't work, please upload some sample data and we can probably solve this quite quickly.
Cheers, Rob.
Bookmarks