Variable Print Area

[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.

 

[Guest]

Hide the rows you don't want to print. Easy to select them, use ctrl/9 to hide (ctrl/shift/9 to unhid

----- Terry Bennett wrote: ----

Any thoughts on this

I have a Worksheet on which I am using 15 columns and, anything up to 25
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' usin
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 simpl
adding a comma after the variable range and then adding $A$251:$Q$251, bu
that then prints row 251 on a separate page! (Not what I want

Any suggestions

Many thanks

 

[Terry Bennett]

Thanks, but the file will be used by users who will not be well versed in
Excel. I need to find an easier way than this.

 

[Dave Peterson]

Maybe a different approach:

Move your totals to row 1 and then you won't have to worry. You can make it so
that row 1 is repeated on each printed sheet and they'll always be handy.

Or add a helper column in column A (outside the print range). Put a formula
that evaluates to Hide or Show. Train your users how to use the autofilter
dropdown on that column before they print.