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

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" <pmms@discussions.microsoft.com> wrote in message
news:7E28CB27-BAE9-41C9-B577-315D9D49F974@microsoft.com...
>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" <pmms@discussions.microsoft.com> wrote in message
> news:7E28CB27-BAE9-41C9-B577-315D9D49F974@microsoft.com...
> >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" <pmms@discussions.microsoft.com> wrote in message
news:57EA7EAB-95B5-4E40-899A-0ADABA8F4D3B@microsoft.com...
> 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" <pmms@discussions.microsoft.com> wrote in message
>> news:7E28CB27-BAE9-41C9-B577-315D9D49F974@microsoft.com...
>> >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 :-).
>>
>>
>>