I am attempting to find out how to adjust a Macro that prints a range and then renders the formulas (in the printed range) as values, so they do not change after printing.
The Macro, that I'm using, utilizes a "Get" command to allow the user to select which portion or page will be printed. There are 50 or 60 pages that can be printed.
I am asking for help in how to cause a range value command, or what ever is proper, to access the same "Get" number and use it as well, without making the user retype the desired print range.
Thanks
The Macro, that I'm using, utilizes a "Get" command to allow the user to select which portion or page will be printed. There are 50 or 60 pages that can be printed.
I am asking for help in how to cause a range value command, or what ever is proper, to access the same "Get" number and use it as well, without making the user retype the desired print range.
Thanks