print area filter

  1. L

    Worksheet print from a dropdown list

    My problem is coding a drop-down list that selects the worksheet that needs to be printed. The worksheet information to be printed reside in the column "C". In this example, I am showing the dropdown the "vv" selection and I am printing the "sheet1". I see that the formatting is not working in...
  2. R

    set print area for multiple sheet at the same time

    I have a file that contains 25 worksheets w/ all same formatting. Now, I need to set the print area to A1:N58 for sheets("firstone") and set the print area to A1:N40 for sheets("secondone"). I only know how to do this for 1 worksheet (activesheet) at a time. Below is what i used...
  3. T

    Ignoring blank or "zero" rows when printing - Help with print macro

    I'm trying to create a macro that will, when printing, ignore the rows in my spreadsheet that either contain zeros or are blank; the spreadsheet is large and I don't want to print pages of rows with useless information. I have an older version of the workbook from 2007 that contains such a...
  4. D

    Making a dynamic ranged print area that also only prints within a date range

    I'm trying to make a dynamic print area that works like a dynamic range but also has condition that checks the data against a starting and finishing date and only prints the rows that are within these dates. Is this possible without VBA or Macros My dynamic range is like this...
  5. U

    Filtered print area

    I moved a process where Microsoft Word is normally used into Excel. In a nutshell, I have 80 or so letters, each representing a different client, that are sent weekly. Each week, not every client gets a letter and there are only small differences between each letter (address, name, amount...

Watch MrExcel Video

This Week's Hot Topics

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
Top