Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save Data not Formulas
Is there a way to save just the data in a spreadshhet and not the formulaes
from a VBA Module. -- CharlesM |
#2
|
|||
|
|||
For each worksheet in that workbook, you can copy|paste special|values and save
it as a new workbook. Option Explicit Sub testme() Dim wks As Worksheet Dim newWkbk As Workbook ActiveWorkbook.Worksheets.Copy 'to a new workbook Set newWkbk = ActiveWorkbook For Each wks In newWkbk.Worksheets With wks.UsedRange .Copy .PasteSpecial Paste:=xlPasteValues End With Next wks Application.CutCopyMode = False MsgBox "Please save this new workbook!" End Sub Charles wrote: Is there a way to save just the data in a spreadshhet and not the formulaes from a VBA Module. -- CharlesM -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Formulas in source data | Charts and Charting in Excel |