Excel vba set print area multiple ranges I've named a few of the ranges and tried to print them, but there seems to be no method to do just that. Sep 8, 2014 · Trying to set a range variable = to current print area. Print Area Aug 23, 2025 · Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but you can use a macro to make the print ranges the same. You can use VBA Union to combine multiple ranges or even grab a subset of a larger range. WorksheetFunction Jul 9, 2018 · This has me stumped and cannot find anything close to a solution, any help appreciated. You will see that Excel is smart enough to only create pages where data exists. Is there a macro I can create to set the print area automatically of this table? Aug 6, 2010 · Hi, I have got "Estimate" sheet, for which I want to set a multiple print area. Also, it it will show you all the print-related VBA codes. Excel - Print Out Multiple Ranges This macro prints out multiple ranges of a worksheet. In Aug 5, 2010 · loop through rows until you find a cell in column Q that contains "Stop", then print the range above it. PrintArea = Range (rng1) Jul 17, 2023 · This tutorial explains how to set a print area in Excel using VBA, including several examples. Range("E106"). Value Dim i As Integer I'm having difficulty putting in order a code to do the following: Set the print area for each sheet [This is variable since each sheet may contain different amount of rows] - Each sheet has the same headers on the first row and the header runs from A1:N1. Oct 24, 2025 · This detailed guide walks through every essential technique for automating print areas in the active worksheet, including setting, clearing, resizing, fitting to pages, adding titles, previewing, printing, and PDF exporting. Oct 25, 2022 · In this tutorial, you will learn how to set print areas in Excel and Google Sheets. Since it is a named range, you can modify it in the Name Manager. Jan 29, 2018 · Struggling with some VBA to print multiple print ranges to one document ( 3 pages) Code below is my attempt so far but I am not sure how to print an array for multiple ranges ! Nov 13, 2016 · Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim ws As Worksheet Dim lastRow As Long Set ws = ThisWorkbook. Jun 6, 2018 · Any ideas how I can do that please ? Thanks in advance ! Update #1: Here's a screen shot of only a slice of my data range Even if I set the . methods were used for this article. Feb 13, 2023 · The names of those containing data are stored in a column. PageSetup properties to manually fit page breaks. This problem is stated as printing non contiguous rows, columns or any part of the sheet. If this quick guide helped you learn a new Excel skill, feel free to share your thoughts in the comment box. Apr 3, 2025 · Range Areas: Exploring Range Areas: A Comprehensive Guide to VBA Set Range 1. I want to create a range which excludes some rows. pdf? Feb 1, 2018 · Hey guys - I need to be able to set print area using named ranges that vary dynamically. So for the attached example I would need the print area set for the following: A2:H2 A18:H22 A26:H29 A32:H34 May 28, 2019 · I have about 10 pivot tables in one sheet moving across the sheet from A1 to BM1. Setting the print area in Excel enables you to print specific sections of your reports, saving paper and ink or toner. Choose the Set Print Area option. PrintOut Preview:=Preview End Sub P1, P2 etc are all named ranges which are on the same worksheet (Scorecard Monthly). Excel 9286 2166 0 0 Add to collection (0) (0) Feb 25, 2024 · Master Excel VBA code for page setup with our easy-to-follow guide. In Excel, the print area is a range of cells only required to be printed from the spreadsheet. dim rng as range Set rng = ActiveSheet. Jun 28, 2013 · I want to print Multiple copies of that one sheet. Let's say you have a couple of helper columns in an Excel workbook and don't want these columns to be printed but you want the columns to be visible. Apr 1, 2025 · When working with Microsoft Excel, one often encounters the need to print specific portions of a spreadsheet. The number of rows is determined by finding the last row used. Oct 10, 2014 · I have 2 ranges (fixed) in 2 different sheets which I want to print in a single file in different pages, prompting the user by the Print dialogue box only once. Range("A1"). Can there be multiple ranges in one For loop to make this work instead of the following code? You can have multiple print areas in a single sheet and then save that file to save the print area and the file. Address End Sub However, when I click File -> Print, the range of columns A to K up to row 1000 is displayed instead of only the Complete step-by-step explanation of how to setup a page, print or print preview from Excel with VBA. PrintArea = . I don't want to have to keep selecting the range and make Jun 11, 2025 · Print Area or Set Print Area is an Excel Page Layout command that allows you to control which part of the worksheet you want to print. So, download the workbook to practice. How can I print multiple ranges and worksheets to a single . Nov 21, 2022 · Hi, I am trying to create a VBA code which will generate a pdf report where multiple ranges from a sheet will be printed onto one page. Excel will print only enough sheets as needed for cells containing content. Nov 24, 2022 · 1 Below is given a VBA code found online which is helpful to print desired ranges from an Excel but not sure how to improve it in order to fulfil the following condition. Is there a way to print a named range in Aug 1, 2024 · Learn how to set print areas across multiple worksheets in Excel for streamlined printing. On the worksheet, enter values in random cells in columns A through C. Aug 1, 2002 · In Excel VBA, I have selected and named a range based on the number of rows of data in the spreadsheet. pdf file: 'More coding above With Sheet7 If (CheckBox1. I need my print area to be rows A2:H2 (headers) and all the rows (from A to H) which have an entry in column M but not in column P. ) Jul 1, 2021 · As a rule, Excel automatically sets page breaks for printing based on paper size, scale, specified number of sheets in width and height, page orientation, and other parameters. Running the VBA Macro, it detects two selected cell ranges, as you can see with the output “# of Area (s): 2”. Easy step-by-step guide for Windows, Mac, and Excel 365. com/academy ★ About this video ★ Want to be able to easily switch between multiple print ranges? Feb 4, 2009 · Insert the following macro code in your Visual Basic Editor to have Excel select the custom view and print it out all in one click! Note: The macro code will print one custom view (currently set to print the details from the example above). This is where the concept of a 'Print Area' becomes invaluable. This property is particularly useful when dealing with non-contiguous ranges – that is, multiple Jul 27, 2024 · Want to print small, non-contiguous areas of your worksheet all on a single page? You might think that defining a non-contiguous print area is the key to doing this. Jul 17, 2012 · I'm assuming there's a way to put all the necessary sheets and ranges in something like an array and then do a . Dec 21, 2024 · Click the Print Area tool. Once I have named the range, how do I program the VBA code to print that named range? May 24, 2024 · This article will help you visualize 5 different ways to print range to pdf using Excel VBA. Given that I need a dynamic print area (one that changes based upon content), another approach must be employed. The values in the range of cells can c Excel - Set Print Area This macro sets the print area of a worksheet. Print rngCell. When the button is clicked, it will automatically print the specified table. I am trying to copy multiple ranges using Excel VBA. Also, if you know of any other ways to highlight cell ranges in a If you regularly save a range of cells in Excel to PDF using the user interface options, using VBA instead can save you time and effort. Can there be multiple ranges in one For loop to make this work instead of the following code? Jul 23, 2018 · What I mean is that Excel has a standard procedure for static Setting a Print Area whereby the user selects Page Layout>Print Area>Set Print Area. In VBA you can treat it as a range like this: Dim Rng as Range Set Rng = Sheets ("Sheet3"). Mar 15, 2023 · See how to set, change and clear print area in Excel manually and how to define print areas for multiple sheets by using macros. PageSetup If 'condition is met' Then . PrintOut End With the used range is well Jul 9, 2018 · I want to write vba code for setting print area. Now, do a print preview. Whatever range it refers to is what will be printed when you choose to print. PrintArea = ws. Excel displays two options. Learn to print a single worksheet or multiple worksheets with VBA in just few seconds. Value = True And CheckBox2. To set a print area in Excel VBA, you can use the PageSetup. I understand that in order to select multiple ranges, syntax similar to that below is used: Range("A1:B4000, F1:F4000"). Thanks for any help in advance. Feb 6, 2023 · ★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid. Nov 29, 2017 · ' you cannot debug print the object itself 'Debug. PrintArea property (see below in the Aug 4, 2024 · The article shows 5 easy methods on how to print range of cells by excel VBA. Select 'printsettings code Next wSht Apr 13, 2011 · On worksheet 3 is data that applies to worksheet 1 and worksheet 2 Data related to worksheet 1 is range a1:h10 Data related to worksheet 2 is range a12:h21 Need macro to say when I print Worksheet 1 it will print preview Worksheet 3 range a1:h10 in portrait as well as include Worksheet 1 set print range a1:m36 in landscape in the same document. Application of Print Area in Excel Focused Printing: Define specific sections of your spreadsheet as the Print Area to ensure only essential content is printed, reducing waste and improving document clarity. first page is introduction (A1:Q53) and from A54 onwards i want to print upto end of data. Address . Jul 30, 2024 · Add to Print Area Adjust Print Settings Conclusion Mastering how to set multiple print areas in Excel can significantly improve your workflow, especially when working with large and complex spreadsheets. Get expert tips, ask questions, and share your love for all things Excel. Value Next rngCell ' use the Transpose function for a single row or column Dim strData As String Dim wsf As WorksheetFunction: Set wsf = Application. Mar 30, 2022 · Set this property to False or to the empty string ("") to set the print area to the entire sheet. The range can vary depending on the period I select for the data in the pivot tables. May 12, 2016 · Setting the print area on a moving range can be a difficult and frustrating thing to trap. Rows. I can't upload the file, but i think i can upload a printscreen showing the page breaks. When you save the workbook, the print area will also get saved. At the bottom of these twelve pages is an additional 2-page section that I only need in certain instances. PrintArea property of a worksheet to specify the range you want to print. This tip shows how to specify that print range from within a macro. Jul 6, 2024 · This article demonstrates to print specific sheets using VBA macro in Excel. PrintArea = “A1:B10” sets the print area to cells A1 through B10. CurrentRegion. When executed, it prints out multiple selections into one page but does not properly fit them. Jul 3, 2024 · In this article, we will discuss 5 examples related to setting the print area for multiple ranges using VBA in Excel. Activate ActiveSheet. Jan 30, 2024 · Excel VBA code for print can help you generate multiple copies of your data, set specific print settings, or even automate the entire printing process to save time. The ranges will always begin on row 84 but the end depends on how far down the data goes. Elevate your spreadsheet skills with us! Aug 10, 2017 · This code uses column A to determine the last row and uses row 1 to determine last column. Count, 1). This will loop through your workbook and set the print area to that range of rows/columns. You’ll need to copy this macro for as many custom views as you have. Like right now I have Sheets ("name"). Sub TestUnion() Dim Rng1 As R Oct 16, 2019 · Re: EXCEL 2007 I have a series of ranges in one worksheet that together comprise a multi-page list of items (songs in playlists). Jun 18, 2024 · We can set print area in Excel for multiple pages very effectively following the 2 ways described in this article briefly. Value = True) Then Aug 4, 2024 · This article illustrates 3 different methods to select and set the print area of a dataset to selection using VBA code in Excel. In Excel 2013, having sheet named "Tags", I am trying to set a printing area from A2 till end of page, ending with column L. Apr 23, 2024 · Excel VBA also allows you to refer to multiple ranges at once by using a comma to separate each area. Any assistance would be greatly appreciated Oct 1, 2014 · Here is the code i currently haveit sets the print area way to the right of the last used column so it prints two sheets instead of 1. Range ("Print_Area") Note that you must include the worksheet since the named range is scoped to it. Jan 20, 2020 · I have two ranges, each containing a single cell (for example "A1" and "C3"). A Print Area in Excel refers to a range of cells that the user designates to be printed, as opposed to printing the entire Setting the print area in Excel enables you to print specific sections of your reports, saving paper and ink or toner. Oct 3, 2016 · I am a beginner at VBA and am trying to highlight only empty cells in columns N and AA only. It defines the parts or cell ranges for printing. Users often want to print only the specific area of the spreadsheet instead of printing the entire sheet. To download the file Oct 14, 2016 · Sub Print_Info() Worksheets("Scorecard (Monthly)"). A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. Excel has different ideas, however, about what should print. I have the range values in a different sheet ("PrintingMargins") Now, columns D and E in this last sheet contain the cell locations of first and last cells of each range. The Range, PrintOut etc. The result was a new range containing only the value of Rng1. kindly suggest the command. Nov 5, 2017 · Excel names the print area "Print_Area", a named range scoped to the worksheet level. I need to use these names as Print Areas in a macro to loop through and print each of these ranges on a separate page. PrintArea = Current. thanks everyone for giving me a part out of ur time. As an example, create a new worksheet. PrintArea = "P1,P2,P3,P4,P5" ActiveWindow. For example, see the below syntax used for referring to all ranges shown in the image: Nov 8, 2021 · This is my current code and I have tried various combinations but it only prints the info in Columns A and B and ignores all data in Columns D to O Sheets("PartsList"). Select Dim LstRw As Dec 12, 2019 · I want to create multiple buttons where each button is linked to a specific table in a worksheet via VBA. Example - I have a workbook with multiple worksheets A to H. May 14, 2022 · Need to print more than one portion of your worksheet? If you use named ranges for the different ranges you want to print, you can apply the technique in tip to print whatever named ranges you want. I have seen vba succeed throughout this project when Excel formulas failed (thanks to the community for the many sections of code I have Oct 16, 2021 · Hello, I am trying to use a macro to print a number of pages based on the highest value in a range of cells. Some are bigger than others but on the whole they are all pretty similar. PrintArea There is more to it than this, but this is where I am getting stuck, Getting a Ru By addressing these common print area problems, you can ensure that your Excel spreadsheets are printed correctly. Aug 12, 2024 · In this article, I've explained 7 smart ways how to change print area in Excel, problems with solutions, and other related things. Feb 16, 2002 · How can I set the current selection as the print area within a macro. PrintOut End With the used range is well May 9, 2023 · Select the Set Print Area option to set the print area to the selected range, or select the Clear Print Area option to remove the print area selection. Let’s consider your worksheet contains some datasets from columns A to I and rows 1 to 21. How do I get a new range containing all the cells between these two ("A1:C3")? I tried this: Set NewRange = Range(Ra Aug 24, 2016 · excel automatically puts a page break between rows 43 and 44 (creating a one row page) and anoter page break at row 89 creating a 2 row page. Sep 19, 2018 · I have the following code that exports the selected range in the worksheet as . Private Sub PRINT_SAVEButton18_Click() With Sheets("Sheet3") . Dim wb As Workbook: Set wb = ThisWorkbook Dim NumberRow As Long: NumberRow = wb. May 19, 2014 · Hi All, I've uploaded a sample sheet which will hopefully be easier. All the data starts at row 2 and how ever many rows down depending on each sheet. Mar 30, 2016 · What code can be used to set the paper size, orientation, print area based on current region in each worksheet? I tried to use the following but it fails: Dim wSht As Worksheet For Each wSht In Worksheets wSht. In this tutorial, I will show you several ways to set single and multiple print areas in Excel and how to modify and clear them. Jun 7, 2018 · I have twelve diffirent ranges that I may need to include to print area. And then loops through each of the cells and prints out the cell address of each selected cell. This takes considerable time. Introduction to RangeAreas in VBA In the realm of Excel VBA, the `Range. Corrected code: May 24, 2018 · I would like to combine the 3 ranges and print one file with 3 pages so I can choose to save those 3 pages into 1 PDF file when I am done. Sheets("Admin Panel"). Therefore, we can control the Print_Area like any other named range, we just have to use the correct name. You could manually set the print area to Jul 6, 2024 · How to print with VBA in Excel. We export pdf to excel through some external code but to save file as pdf we just use simple VBA code. Richard Feb 1, 2016 · John_w J C Autopopulate print tile/print area by locating 2 reference cell locations within an array cgtx82 Mar 27, 2025 Excel Questions Replies 0 Views 280 Mar 27, 2025 Feb 8, 2017 · If we set a print area using the standard Excel Ribbon: Page Layout -> Print Area -> Set Print Area this will automatically create a named range called “Print_Area”. End(xlUp). Download our practice book, modify data and exercise. Dec 5, 2020 · Excel allows you to specify a print range that defines what should be printed from a given worksheet. This property applies only to worksheet pages. there are empty cells on first page hence if i give command to search end of data it stops at first page itself. I tried Union. Print rng ' iterate the range Dim rngCell As Range For Each rngCell In rng Debug. UsedRange. May 28, 2019 · Hello, I have about 10 pivot tables in one sheet moving across the sheet from A1 to BM1. I have a code that sets up the Print Area for a document Dim count As Integer count = ThisWorkbook. Clunky? Yes, but it lets you print with the click of a button. PrintingMargins: D4 = A3 E4 = G46 (that Jul 6, 2020 · How do you define the ranges and where they would copy in VBA? (Sorry - a bit of a VBA novice - I cobbled my example together just with google and trial and error). Here is part of my code so far: With ActiveSheet. I have a table with a fixed number of columns, but the number of rows vary week on week. Select This works fine in Jul 9, 2018 · I want to write vba code for setting print area. Jun 11, 2025 · VBA scripts are available to select print areas in different ways, like for the selected range, on multiple sheets, multiple print areas on the same sheet, and so on. Jun 16, 2014 · Hi, I need to export as a PDF multiple ranges on a single sheet. May 24, 2016 · I've tried to set the print area as a dynamic function, however, with any slight modification in the printing parametrs (switching from Portrait to Landscape), I realize that the print area becomes a static function. PageSetup. Next, set the print area to $A:$B. PrintOut to that variable, however I haven't gotten this to work. PrintArea setting for each sheet Validate the value of NumberRow before using it. Selection but I have no knowledge of VBA. Example: If Q20 equals "Stop" (or I can use a number like 1), then set print range to A1:P20. Jul 28, 2024 · 5 useful Macros to use VBA code for the print button in Excel. You can use VPageBreak object and HPageBreak object in combination with a number of . I am trying to create a macro that will select the top cell of each pivot table, ctrl+shift+down to select its dynamic depth, set the selection to an object, and then set the print area using a union. How do I add multiple print areas in Excel? Dec 21, 2009 · Then select the current range (or any range on that sheet), and in Page Layout goto Print Area-->Set Print Area. Jan 17, 2008 · One Work-Around What I did simply to get it done: Set a range name for each print area you want; Record a macro for each print area that requires different print settings; Insert a cool-looking button or shape and assign a macro to it; Do this for each area you want to print. . In this tutorial, I will show you six examples of printing a range of cells in Excel to PDF using Excel VBA. Here is the code I am up to at the moment: Sub In this tutorial we are going to look at how we can create dynamic print ranges for multiple data ranges on the same worksheet in Excel. Note that you cannot set page breaks with the . SelectedSheets. Below is an example of what I already have: 1) In the name manager I have set Learn now to use a small Excel VBA Macro to dynamically adjust your print area in your Excel worksheets. PrintOut but i want to be able to print a number a copies from a web developer box. HTH, If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. For example: Worksheets (“Sheet1”). Currently I am opening all 30+ Single Excel File Payslips generated by Excel VBA (not done by me) for my company one by one and setting to print by Set Print Area for EACH Payslip Standalone Excel File, and printing them one by one. For example, I have 4 named ranges and they are: Range1 Range2 Range3 Range4 Now in one scenario, I want the PrintArea to be set to = Range1,Range3 In another scenario, I want the PrintArea to be set to In this article, we will learn How to Print Non-Contiguous Areas in Excel. Dec 8, 2009 · Hi everyone, I would like to request some help with the following problem. Sheets("CR") ' find the last row with data in column A lastRow = . Unfortunately these ranges need to printed in a very specific order for a monthly report and it's easier to keep them on separate tabs. Learn how to save as how to save excel range as pdf using VBA. This is a reserved name which is purely for the print area. The "Freezer_CP055_1,2,3" are all named ranges in my workbook. Range("A1:K" & lastRow). Something like ActiveSheet. Each area will be printed on a separate page. When you set a print area in this manner, Excel creates a named range called Print_Area. So for the attached example I would need the print area set for the following: A2:H2 A18:H22 A26:H29 A32:H34 I've tried doing a range with multiple arguments but it breaks once I move away from Jul 17, 2025 · Learn how to set, edit, and clear print area in Excel to print selected cells only. WorksheetFunction Set the print area for each sheet [This is variable since each sheet may contain different amount of rows] - Each sheet has the same headers on the first row and the header runs from A1:N1. Worksheets("sheet2"). I have a worksheet that prints a 12-page document, with data pulled from separate sheets. You may wish to trap a specific range with your print area or have the print range only consider certain columns. Feb 8, 2019 · The VBA Union method in Excel is designed to combine ranges into a single range. I'd like to be able to set each page's print setup so that each 'print area' range fits to the width of the print paper (or PDF Nov 30, 2011 · Hi, I'm looking for a way to set the print area based on the value of a cell. Each worksheet has identical page setup (ranges Jul 6, 2024 · 3 simple macros to display a print preview in Excel VBA. For example, if Jul 23, 2018 · What I mean is that Excel has a standard procedure for static Setting a Print Area whereby the user selects Page Layout>Print Area>Set Print Area. Use For loop to apply PageSetup. Elevate your spreadsheets and printing precision today! May 9, 2023 · The process for setting print ranges for multiple worksheets in Excel involves selecting the worksheets for which you want to set print ranges, selecting the print area for each worksheet, and then grouping the worksheets together to print as a single document. In order to achieve Dec 14, 2016 · Hi there, I have a workbook and each sheet has a different range set as the print area. How can I set all 3 ranges to three seperate print areas and have it become 3 seperate pages where I can simply print from pages 1 to 3? Jun 24, 2023 · Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but you can use a macro to make the print ranges the same. For example if you need to print only partial data on a sheet which is not at one place. May 19, 2014 · I've uploaded a sample sheet which will hopefully be easier. You can select multiple print areas in a worksheet. Sep 24, 2015 · Hello, I am very new to VBA and I am looking to create a macro to define the print area for each worksheet in my workbook. Scenario: Working with Printing Excel sheets, Excel does not allow you to print multiple ranges or columns of a sheet on page. Areas` property is a fascinating feature that often goes unnoticed but holds significant potential for those who delve into its capabilities. Now you can go back to the Name Manager and in the newly created Print_Area name, use Refers to: =ref_PrintArea You may need to adjust the range references, but it should be a start. It will be the max row number on sheet if there isn't any data under cell N21. Aug 31, 2024 · Conclusions So far, you’ve learned how to view the print area in Excel in six intuitive methods, like the Print Preview tool, the Page Layout view, the Page Break Preview, Named Ranges, Go To dialog, and Excel VBA. When running the vba, the resulting print out doesn't output in the correct order ( as specified in the VBA) - I think this is because Feb 24, 2017 · I'm pretty new to VBA and Excel. May 9, 2023 · Automatically printing a range in Excel can save time and effort: By setting up the print area, creating a macro for printing, and running the macro to automatically print, users can streamline their printing process and free up time for other tasks. (It also shows how you can automatically set the range without using a macro. Sep 11, 2020 · Re: vba macros to set print area for multiple sheets with a selected range If you mean that the printout isn't printing column K, then try changing the print scaling or the margins in Page setup. Follow our step-by-step guide to print your data efficiently. I would like to use some code to set a non contiguous print area using columns A to E and K to AE. When you print a worksheet after defining a print area, only the print area is printed. I'm using Excel 2010 and so I just use the "Adobe PDF" Printer. Cells(. You can copy the code and try for yourself. Til now, I've been selecting the range and printing it from the PRINT/SELECTION command. Any help would be greatly appreciated. 2 comprehensive code examples you can use right now. I would like to export A2:E55, Then G2:to the end of J ??, K2: to end of Q. A vibrant community of Excel enthusiasts. In order to fit print ranges 3 and 4 to the width of a page it has to shrink the data. Apr 4, 2025 · When dealing with complex Excel workbooks, specifying print ranges can be a nuanced task, especially when you need to print multiple areas that are not adjacent to each other. Print Area on Selected Range To set the print area a Dec 10, 2019 · My Pain Point: I’m the person printing the Payslips for the Company. I would like the header row to be the title on each page if multiple pages need to be printed Set the format to landscape I Dec 10, 2020 · I have values in a tabular format. To rephrase my request: I'm looking for a way to print different ranges in multiple pages. My problem is how to select each Cell Value to use as the name of a Print Area. Apr 22, 2016 · Print ranges 2 and 4 have several more columns than print ranges 1 and 3. PrintArea setting on Sheets object/collection (multiple sheets). but, you’ve set up a Print Area for the cell range F1:I10. Currently this is the code I am using and it is assigned to a button; the trouble I have is that instead of setting the print area to the last cell of each worksheet (the The easiest way to set a print area in Excel is to select the range you intend to print, go to the ‘Page Layout’ tab, choose ‘Print Area’ in the ‘Page Setup’ group, and then click ‘Set Print Area’. Apr 1, 2024 · You can't apply PageSetup. What is Print Area? Print area in Excel is nothing but a pre-selected area in a spreadsheet that you want to be printed on paper. Row ws. Excel 6222 2129 0 0 Add to collection (0) (0) Jan 17, 2018 · I have a workbook with multiple sheets that have specific ranges that need to be printed. Range("N21 Oct 8, 2019 · I need to select multiple ranges in a worksheet to run various VBA code on them. By following the steps outlined above, you can ensure that only the necessary parts of your worksheet are printed, saving both time and resources. PrintArea to A:D, it still give the same result. Jun 17, 2024 · You can set the print area in Excel by selecting the Print Area option from the Page Layout tab after selecting an area in your worksheet.