| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable print area via a macro
Hi there,
I need a VBA code I can run via a macro. I have a table of data in Sheet1, say starting in cell A1 and finihsing in Z250 - its called the Range. I only want it to print rows that have a certain value in column A. For example, if A3, A21, A45 all have "incomplete" as their value, then only these 3 rows would be printed below the set Print Titles. I also need the option to automatically hide or not print some columns across the page when printing using this macro, e.g. columns D, F and H. Any help with this would be really appreciated. Thanks, Andrew. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using named range to extend print area for variable number of columns | Excel Worksheet Functions | |||
| How do you set up a macro to reset the print area? | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
| Variable print area | Excel Discussion (Misc queries) | |||
Threaded Mode
