Excel create booklet6/20/2023 ![]() Note: This method works well when you have the same range of cells that you want to use while setting the Print Area.īelow is the VBA macro code that will do this: Sub SetPrintAreas1() In that case, you can also use VBA to quickly set the print area in one sheet, and then run the code to replicate it to all the other sheets. In case you have a lot of worksheets, setting the print area manually can be time-consuming. So if you want to print specific areas in Sheet1, Sheet4, and Sheet5, you will have to do it for each sheet separately. ![]() You need to do this manually for each sheet. This would set the print area to the selected cells and when you print this sheet, only the print area will be printed.
0 Comments
Leave a Reply. |