Remove Formuli

[BOONER]

Is there a way to remove all formulas from a workbook or sheet without copy
and paste-values?

[Excelenator]

Do you want to delete the formulas and their values (i.e. clear the cells containing formulas)?

If so you can use F5\Special\Formulas and then hit the delete key.

[Gord Dibben]

You can select all formulas using F5>Special>Formulas

But you cannot delete/remove them without losing the results of those formulas
unless you copy/paste values first or deal with them through VBA code.

Sub test()
For Each cell In Selection
If cell.HasFormula Then
cell.Value = cell.Value
End If
Next
End Sub


What do you wish to do. Perhaps we could help.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 15:34:01 -0700, BOONER <[email protected]>
wrote:

>Is there a way to remove all formulas from a workbook or sheet without copy
>and paste-values?