MrTinkertrai
08-20-2010, 12:37 AM
Hello Excel-gurus,
The other day I was looking for a piece of code that would change formulas into their values.
I found the following piece of code that does the trick :
Sub F2V()
Dim rng As Range
On Error Resume Next
For Each rng In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas).Areas
rng.Value = rng.Value
Next rng
On Error GoTo 0
End Sub
The only range where I would like to change my formulas into values is the range B8:K55.
How can I change this code so that it fit my needs ?
Thanx in advance
Best regards,
Mike
The other day I was looking for a piece of code that would change formulas into their values.
I found the following piece of code that does the trick :
Sub F2V()
Dim rng As Range
On Error Resume Next
For Each rng In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas).Areas
rng.Value = rng.Value
Next rng
On Error GoTo 0
End Sub
The only range where I would like to change my formulas into values is the range B8:K55.
How can I change this code so that it fit my needs ?
Thanx in advance
Best regards,
Mike