multiple print areas

  1. Dr. Demento

    Unknown number of dynamic arrays - how to?

    I've put together a sub that formats the page setup aspect of my sheets. However, there are instances where it falls apart, such as when a table (long & narrow) and a pivot table (or three) (short & wide) occupy the same sheet; in this case I wind up with ridiculously small print (all columns...
  2. B

    Different Print Area

    Can I set up differet area with-in same sheet (ex:Sheet1) The views I want ares 1) potrait 2) Landscape 3) potrait 4) Potrait 5) Landscape 6) Potrait. Please help.
  3. B

    VBA help- Print ranges if not #N/A (multiple print areas on a worksheet)

    Hi, I need to print the following areas that are on the worksheet "Zipcode Summary". Each area A1:U62, A63:U125, ect. should print on its own page if the range does not equal #N/A. I tried modifying the VBA I found, but do not know enough to get it to work. Sub Print_Zips() ' Page 1 If...

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