Translate Formulas as Values
no function can do that
functions cann only change cells' values
you would need a macro to do that
Sub transl()
For Each cell in Selection
cell.Copy
cell.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Next cell
End Sub
|