How to Replace formula with value in Excel cell ?

[Yugal Jindle]

I have complex formula calculating the value of a cell and it calculates the value for me.
I want to get rid of the formula from the cell and want to retain the calculated value.
I have :

Dim range As Excel.Range = getRange()
For Each cell in range
' What should do to retain the value and get rid of the formula in the cell.
Next cell
Please help.. its very urgent !
Its making me nuts.. !

 

[JohnH]

Answered here: How to Replace formula with value in cell using vb.net ? (Excel) - Stack Overflow

cell.Value = cell.Value