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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 :-).
 
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
 
Works like a charm :-) Thanks sooo much!!
Paula

Paul B said:
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
Click to expand...
 
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
 
Back
Top