dwilson38550m
Board Regular
- Joined
- Nov 21, 2005
- Messages
- 89
I have a workbook with 6 or 7 worksheets in it. I would like to create a macro to print selected ranges within each of the 6 or 7 worksheets. I would then like to create a macro button and put it on the "Instructions" tab on the first page of the workbook so that the user can click the macro button and print all the required pages.
I am unsure how to select the print ranges and specify whether I would like each print over 1 or 2 pages etc. Also, could you please provide a code for me to build a macro from? I am also unsure on the macro where to type in the name of the worksheets I am referring to.
Thanks
I am unsure how to select the print ranges and specify whether I would like each print over 1 or 2 pages etc. Also, could you please provide a code for me to build a macro from? I am also unsure on the macro where to type in the name of the worksheets I am referring to.
Thanks