Spreadsheet Printing

I have a spreadsheet template for vendor orders. It is set up for 2 pages of rows to contain data. The number of rows used for data varies depending on how many items I am ordering. Rather than always changing the template, is there a way to only print the spreadsheet with only the rows containing data? if this is not clear, please let me know.

Thanks,
Russ

Hello Russ,

You've got to use a named range for this, which you use as printrange. With a macro you have to change the range based on the last row with values.
I don't know the code to find the address of the last row, maybe someone else can help you with this.

Erik

thanks erik