Try this:

Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
Application.CutCopyMode = False

Rodrigo Ferreira


"Marcus A" <Marcus escreveu na mensagem
...
I wanted to know if there was a macro that would replace all formulas in a
worksheet with their respective value only.

Thanks.