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

"pmms" wrote in message
...
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 :-).

Works like a charm :-) Thanks sooo much!!
Paula

"Paul B" wrote:

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

"pmms" wrote in message
...
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 :-).

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

"pmms" wrote in message
...
Works like a charm :-) Thanks sooo much!!
Paula

"Paul B" wrote:

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

"pmms" wrote in message
...
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 :-).