can excel show only the answer to a formula in the cell

[Guest]

I have formulas all over my worksheet. I will, eventually, have many
worksheets that I will be merging. At that point, the formulas (vlookups,
cell references, etc.) will no longer work. Is there a way to just put the
answer in a cell instead of showing the formula? (similar to the "paste
special....value" without having to copy and paste .

 

[Paul B]

pmms, you could use a macro, here is one way,

Sub Remove_Formulas()
'Removes formulas on the active sheet and replaces them with valves
With ActiveSheet.UsedRange
.Copy
.PasteSpecial Paste:=xlPasteValues
End With
Application.CutCopyMode = False
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Works like a charm Thanks sooo much!!
Paula

pmms, you could use a macro, here is one way,

Sub Remove_Formulas()
'Removes formulas on the active sheet and replaces them with valves
With ActiveSheet.UsedRange
.Copy
.PasteSpecial Paste:=xlPasteValues
End With
Application.CutCopyMode = False
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Your welcome, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003