vb.net excel

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...