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

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,516
Location
Norway
Programming Experience
10+
Top Bottom