Vba print selection how to#

'Pages' in the descriptions of From and To refers to printed pages, and not to overall pages in the sheet or workbook. If PrintToFile is set to True, this argument specifies the name of the file that you want to print to. If PrToFileName is not specified, Microsoft Excel prompts the user to enter the name of the output file. False (or omitted) to print the object immediately. True to have Microsoft Excel invoke print preview before printing the object. If this argument is omitted, one copy is printed. With xlPaperLetter Set paper size to 8.5x11 inches.PrintQuality 2400 Set print quality to 2400 dpi.CenterHorizontally True Center horizontally on page.CenterVertically True Center vertically on page. Returns Nothing if no objects are selected. Press Alt + F11 to open the VBA developer window. Returns the currently selected object on the active worksheet for an Application object.

Vba print selection how to#

If this argument is omitted, printing ends with the last page. Print Selection How to Print Selection in excel sheet through VBA Macro Code To use VBA macro code in an Excel spreadsheet, you need to do the following: Open the Excel spreadsheet where you want to use the macro code. If this argument is omitted, printing starts at the beginning. The number of the page at which to start printing. First, select the single cells range or the multiple cells ranges using the Control key that you want to set a print area in the sheet. PrintOut ( From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)Įxpression A variable that represents a Range object. A selection represents either a selected (or highlighted) area in the document, or it represents the insertion point if nothing in the document is selected.