Remove formula and replace with just the value in cell

[cpg84]

Hi,

I have cells that have formulas in them. However, I want to know if there is a quick way to remove the formulas, but keep the value in each cell?

I have a lot of cells with this, so I want to know if there is a quick way.

 

[hurgadion]

Hi,
try the code of the form:

Sub ChCh()

Range("A1:D4").Value = Range("A1:D4").Value
End Sub

Best regards.

 

[cpg84]

Thanks