I have a workbook consisting of a numer of sheets.
In these sheets a lot of calculations are made and the result are displayed in different schemes on the sheets.
On each sheet the user have defined a print area.
My task is now to make a macro that make a new workbook with same number of sheets with the same names with only the data and formats from the defined print areas from the original work sheets.
The purpose of all this is off cause to make a work book without callculations and formulas which can be distributed.
Any help is appreciated
In these sheets a lot of calculations are made and the result are displayed in different schemes on the sheets.
On each sheet the user have defined a print area.
My task is now to make a macro that make a new workbook with same number of sheets with the same names with only the data and formats from the defined print areas from the original work sheets.
The purpose of all this is off cause to make a work book without callculations and formulas which can be distributed.
Any help is appreciated