VBA Excel Printout method can be used to print out any printable objects such as Range, Chart, Worksheet, sheet, object collection such as Charts, Worksheets etc.
- ActiveSheet.PrintOut
- Worksheets(Array("Sheet1", "Sheet2")).PrintOut
- Worksheets.PrintOut
- ActiveWindow.SelectedSheets.PrintOut
- Range("A1:K16").PrintOut
- Chart1.PrintOut
- Charts.PrintOut
- ActiveWorkbook.PrintOut
- ThisWorkbook.PrintOut
PrintOut Syntax
expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas)
No comments:
Post a Comment