Duplicating a workbook only with cell's values

A

Adrix

Hello every body,

I have a complex workbook. It it is becaming a little bit difficul
to work into it. It is possible to do a copy of this workbook but thi
copy should have only cell´s values not cell´s formulas. As I said thi
workbook is complex to replecate sheet by sheet to another workbook an
do the paste especial process.

thank you in advanc
 
R

Ron de Bruin

Hi Adrix

There is no option to save it like this
Try this macro on a copy of your workbook

Sub test()
Worksheets.Select
Cells.Copy
Cells.PasteSpecial xlPasteValues
Cells(1).Select
Worksheets(1).Select
Application.CutCopyMode = False
End Sub
 
O

otium

Only way I can think of is to do a copy of the workbook as per norma
(it will still have formulae) at this stage.

Go into workbook and right click on first sheet name tab and selec
"Select All Sheets".

Now copy and paste special as values for the sheet displayed, it wil
do the same for all of the worksheets.

Ala
 
Top