I am trying to automate the following printing procedure:
I have a workbook that calculates the values of our clients’ investment portfolios. The first sheet (named ‘data’) holds all the variables and does not need to be printed out. The rest of the sheets are named for the client whose portfolio is being valued and my users update the workbook quarterly with new clients, so the number of worksheets changes. On each worksheet there are two ranges which I need to be printed: (b31:j90) which is best printed portrait, and (s91:aj128) best printed landscape.
To try to make things easier I have inserted a blank worksheet named ‘First’ after ‘data’ and one named ‘last’ as the last sheet in the workbook. I am trying to get a macro to selectall sheets from ‘first’ to ‘last’ and then print out the above ranges, changing the page orientation between printouts.