Good Afternoon All,
I have twelve saved Custom Views, named PRINT_1, PRINT_2.... PRINT_12. The 12 Custom Views all come from the same tab (REPORT). Each Custom View is set up to print only the required number of pages. I have a cell (Z9) on the same REPORT tab containing a simple vlookup that identifies which Custom View needs to be printed. So, for example, if I have a 5 page report that needs to be printed, the cell will return "PRINT_5" which corresponds to the Custom View "PRINT_5". I am inexperienced in using VBA and have limited experience recording short macros. I would like to be able to click on a button to print the Custom View specified in cell Z9. Any help would be greatly appreciated.
I have twelve saved Custom Views, named PRINT_1, PRINT_2.... PRINT_12. The 12 Custom Views all come from the same tab (REPORT). Each Custom View is set up to print only the required number of pages. I have a cell (Z9) on the same REPORT tab containing a simple vlookup that identifies which Custom View needs to be printed. So, for example, if I have a 5 page report that needs to be printed, the cell will return "PRINT_5" which corresponds to the Custom View "PRINT_5". I am inexperienced in using VBA and have limited experience recording short macros. I would like to be able to click on a button to print the Custom View specified in cell Z9. Any help would be greatly appreciated.
