#Vba print selection code

Sheets('Sheet2').PrintOut Print the Active Sheet 'only the activesheetĪctiveSheet.PrintOut Print Selected Sheets 'Print all selected sheetsĪ Print Selection 'Print only the selection Range ('A1:G55') it expects a address string not an actual range, so Lowpar suggestion would have worked also. Steps: Follow the first two-step from the first section to create the button and assign a macro. Also, you can select a range from the active sheet and can make a Print Button to print it using VBA. ThisWorkbook.PrintOut Print a Specific Sheet 'Print only 'Sheet2' Embed Excel VBA to Create Print Button for Active Sheet with Selected Range.

#Vba print selection code

Worksheets.PrintOut Print All Charts 'Print all ChartsĬharts.PrintOut Print Whole Workbook 'Print the active whole workbookĪctiveWorkbook.PrintOut 'Print this workbook which the VBA code in expression A variable that represents an Application object. Use the Select method to set the selection, and use the TypeName function to discover the kind of object that is selected. Returns Nothing if no objects are selected. Worksheets(Array('Sheet2', 'Sheet3')).PrintOut Print All Worksheets 'Print all worksheets Returns the currently selected object on the active worksheet for an Application object.

Print Only Hidden Worksheets Sub PrintOnlyHiddenWorksheets()Įnd Sub Print Visible and Hidden Worksheets Sub PrintHiddenAndVisibleWorksheets()Įnd Sub Print Multiple Worksheets 'Print Sheet2 and Sheet3 PageSetup.PrintComments = xlPrintInPlace PrintOut Syntax expression.PrintOut( From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas) Print Worksheets on One Page 'Print Sheet1 exactly one page wide and tallĮnd With Print Worksheets with Comments Sub PrintWorksheetsWithComments()Īpplication.Displa圜ommentIndicator = xlCommentAndIndicator In the Microsoft Visual Basic for Application window, click Insert > Module. To selected multiple areas, hold the Control Key and make the selection. It gets the job done but it does it in a slightly annoying way. There can be multiple print areas in a worksheet, however, these are printed separately. I've found a few places on the internet that pointed me in the right direction but I think my VBA code is a little in-efficient. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Application window. Howdy all I have a question for the general audience about trying to print specific pages in my workbook. You can print multiple selected columns together on one page with VBA code. Here is a large examples of print Worksheets use Excel VBA, Before you read this tutorial, you may need to know the difference between Worksheets and Sheets. Print selected columns together with VBA code. In Excel, when you click the Print button, Excel will not print hidden sheets, except use VBA.