dynamic print range

  1. J

    Dynamic print range changes to fixed range

    I have Excel 2016. Every time I set a dynamic print range it quickly reverts back to a fixed range. Here are my ranges: Print_Area Scope: PURCHASE ORDERS Refers to: ='PURCHASE ORDERS'!purchase_orders_print_area purchase_orders_print_area Scope: PURCHASE ORDERS Refers to: =OFFSET('PURCHASE...
    • jmplajr
    • Thread
    • dynamic print area dynamic print range named range print print area
    • Replies: 1
    • Forum: Excel Questions
  2. B

    Set print area based on Column width

    Hello all, I have a double whammy here. I searched for an answer but seem to find answers regarding rows that are changing, not columns. My 1st issue is this: I have a document with a bunch of summaries that are filled out by different users on a single worksheet. Each summary can be a...
  3. C

    dynamic PrintArea development

    2003 / w7 I have several Advanced filters that differ naturally by length not by width. I'm using a routine to group pages and print a single PDF. It works fine. Now for the "touchy feely" stuff. I'd like to eliminate the unnecessary printed "rows" from the print area. 'GROSS SKINS...
  4. J

    Dynamic print range, stopping at the last visible row

    Goal To have a dynamic print range, stopping at the last visible row. Column C Contains non visible formulas. The formulas start at row 17 and continue to row 200. Sometimes these rows contains visible data and sometimes not. Column D-L Contains sometimes free text. Problem Can’t figure out...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top