Collate (Optional): This is a Boolean type argument.If it is not specified then user is prompt to enter an output file. PrintToFile (Optional): True is passed to print to a file.ActivePrinter (Optional): This sets the name of the active printer.If omitted, FALSE will be passed and hence excel will invoke the printing directly without showing the preview. Preview (Optional): If passed as TRUE then Excel will invoke the print preview before printing the Object.If omitted, only one copy will be printed. Copies (Optional): This is the number of copies to be printed.If omitted, printing will be done till the last page. To (Optional): End page number till which printing has to be done.If this argument is omitted, printing starts from page 1. From (Optional): Starting page number from which printing has to start.For example: Workbook, Worksheet, Chart etc. YourObj (Required): It is a variable which represents your Object which you want to print.YourObj.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas) Where:
Hope you are doing well !! Thought of sharing a small VBA code to help you writing a code to print the Workbook, Worksheet, Cell Range, Chart etc.PrintOut () Method is used to print any Excel Object.
