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

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.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=567249

You can select all formulas using F5SpecialFormulas

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
wrote:

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