| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
print from macro, using if formula
I currently use a macro to print several sheets from one workbook. I would
like the option to print some of the sheets with the condition of the value of a cell in the first sheet being 0. My current Macro looks like this, ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "EPSON Stylus C88 Series on Ne03:", Collate:=True I've been trying to use the following, ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "EPSON Stylus C88 Series on Ne03:", Collate:=IF(Title!D90,"True") and ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "EPSON Stylus C88 Series on Ne03:", Collate:=(IF(Title!D90,"True")) Any help is greatly appreciated. -- hog1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a print macro to print only a certain number of pages | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
| HOW DO I PRINT USING A MACRO? | Excel Discussion (Misc queries) | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
Threaded Mode
