3/16/2023 0 Comments Windows print selection excelWhen multiple sheets are selected, the active sheet is the one which is visible when you run the macro.ĭim SelectedPrintAreaRangeAddress As String Dim Sheet As Worksheet This macro automatically sets the print area(s) for all selected worksheets the same as on the active sheet. Set print area in selected sheets as on the active sheet If you have to print the same area on multiple sheets regularly, the use of VBA can speed up things. Luckily, there is an easy workaround described in How to print the same range in multiple sheets. The problem is that selecting several sheets disables the Print Area button on the ribbon. In case you have a lot of worksheets with exactly the same structure, you will obviously want to output the same rage on paper. How to set print area in Excel for multiple sheets with VBA
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |