How to Replace formula with value in Excel cell ?

Yugal Jindle

New member
Joined
Jul 26, 2011
Messages
2
Location
New Delhi, India, India
Programming Experience
Beginner
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.. !
 
Back
Top