T
Terry Bennett
Any thoughts on this?
I have a Worksheet on which I am using 15 columns and, anything up to 250
rows.
When printing, I only want to print the rows with data in them (ie; 1 - 150,
or whatever), but I also need to print row 251 which has totals in it.
I have set-up the Print Area, re-defining the named range 'Print_Area' using
OFFSET and COUNT functions - that is fine for the first x number of rows.
But, how do I get it to also print row 251. The best I can get is by simply
adding a comma after the variable range and then adding $A$251:$Q$251, but
that then prints row 251 on a separate page! (Not what I want)
Any suggestions?
Many thanks.
I have a Worksheet on which I am using 15 columns and, anything up to 250
rows.
When printing, I only want to print the rows with data in them (ie; 1 - 150,
or whatever), but I also need to print row 251 which has totals in it.
I have set-up the Print Area, re-defining the named range 'Print_Area' using
OFFSET and COUNT functions - that is fine for the first x number of rows.
But, how do I get it to also print row 251. The best I can get is by simply
adding a comma after the variable range and then adding $A$251:$Q$251, but
that then prints row 251 on a separate page! (Not what I want)
Any suggestions?
Many thanks.