ignoreprintareas=false

Help with macro please. The Sub below works fine with Excel using Windows 10 however I am migrating to Excel in MAC. When I run the macro I get an Error while Printing message. If I go to DEBUG and change the path to “DATA1\DATA\DROPBOX\BUSINESS\PDF_INVOICE" I still get an error but this time...

In part of my print macro, I have this ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate _ :=True, IgnorePrintAreas:=False Now what does IgnorePrintAreas:= False mean please? where can I find what all of these mean? Ron

Hi I've written a code to print specific sheets based on the name, viz. Sub MyPrint() Windows("161082.xlsm").Activate Sheets(Array("P026", "P062", "P125", "P461", "P645", "P721", "PMF15", "PMF57", "PMF62", "PMF65", "PMF66")).Select ActiveSheet.ExportAsFixedFormat _...

Hei guys, I have an excel workbook which contains worksheets, say, W1 to W9. I recorded a macro to print the sheets and it is working fine to certain extent. The code is like this: Sub Macro1() Sheets("W1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=3, Collate:=True, _...

Hei guys, I have an excel workbook which contains worksheets, say, W1 to W9. I recorded a macro to print the sheets and it is working fine to certain extent. The code is like this: Sub Macro1() Sheets("W1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=3, Collate:=True, _...

Currently have a macro to instruct for the print the workbook sheets as follows, but I am lokk9imng for a code that would prompt to select which printer to print, can anyone help? Sub Macro2() ' ' Macro2 Macro ' ' Keyboard Shortcut: Ctrl+Shift+P ' Sheets("Charge Sheet").Activate...

Hello Mr Excel, I recorded a macro to print individual scorecards for six people. I have to get the name into cell C12 to update the information and then print the scorecard. Am I able to automate this macro to allow it to print more than six names and stop at the end of the last name (stop at a...

Hello All I need help with this macro please Sub Macro4() ' ' Macro4 Macro ' ' Range("Q2:X2").Select ActiveCell.FormulaR1C1 = "4" Range("Q3:X3").Select ActiveWorkbook.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False Range("Q2:X2").Select ActiveCell.FormulaR1C1...