Or, select the additional non-adjacent range of cells in case you want to add a new print area with the existing print area in the spreadsheet. To set Print Area in Excel spreadsheet, first select (highlight) Cells that we want to set as Print Area, and then navigate to ribbon Page Layout > Print Area > Set Print Area To set Print Area in Excel VBA, we have to use PageSetup.PrintArea Property. First, select the additional adjacent range of cells in case you want to expand the current print area selection. The statement below prints the selected worksheet on my default printer which I am happy with. The only syntax Im managing to find is the Zoom method but as far as. Thus, that print area selection gets expanded and when a user adds non-adjacent cells range then Excel creates that range as an additional print area selection that Excel prints on a separate page. All I want to do is print a selection and scale it to fit on a single landscape page. When a user adds the adjacent cells to the existing print area then Excel includes those cells within that existing print area selection. Add Cells and Ranges to the Print AreaĪnytime user can add the cells to expand the print area selections or to create the additional print area. The print area selections get saved, when you save the workbook, and each print area selection prints on a separate page means one print area selection per page. To view the print area selections, go to the “View” tab and click on the “Page Break View” icon and you will find the page breaks preview based on the print area selections. 
After that, go to the “Page Layout” tab and click on the “Print Area” icon and then select the “Set Print Area” option.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.
#Vba print selection how to#
We have quick and easy steps mentioned below on how to set and modify the Print Area selection in Excel. Users can create multiple print area selections within the spreadsheet and each will get printed on a separate page. I am getting this 1004 error when I try to enact the macro. In Excel, many times users only want to print only the specific area of the spreadsheet instead of printing the entire sheet.įor this, the user can define and create a printing selection area and once the printing area gets selected, every time user will get the print of that selected area range only. 1 Hello, I am trying to set up a few macros that will select a set of cells, select the print option, select print only selection and then press print. Worksheets('Sheet1').Activate Support and feedback. Note that you use the Address property to return an A1-style address. In Excel, the print area is a range of cells only required to be printed from the spreadsheet. This example sets the print area to the current region on Sheet1.
0 kommentar(er)
