REMOVING WORKBOOK'S ALL FORMULAS
Forgive a Student's lack of attention. Perhaps this macro can be adapted to
meet your needs:
Sub Macro1()
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Owner\My
Documents\copy.xls"
For Each sh In Sheets
sh.Activate
Cells.Select
Selection.Copy
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
Next
ActiveWorkbook.Save
End Sub
--
Gary''s Student - gsnu200811
"FARAZ QURESHI" wrote:
It was stated I want values!
--
Best Regards,
FARAZ A. QURESHI
"Gary''s Student" wrote:
In the new workbook, do you want the formulas replaced by blanks or by the
values from the old workbook?
--
Gary''s Student - gsnu200811
"FARAZ QURESHI" wrote:
I have a workbook consisting around 20 sheets. I want to copy all the same to
a new workbook with only "values". Any shortcut how to remove all the formulas
instead of copypaste specialvaluesok on every sheet?
--
Best Regards,
FARAZ A. QURESHI
|