Converting formula into values.

[aligahk06]

Dear Members,

As i have an excel sheet with so many formula in random cells.
After completing my job i want to convert all cell i.e having formula that return value is converted into value itself.
I mean formula disappear and only value remains.

As per my knowledge there is one option after copying paste special as value . But this process take so much time.
I want an alternate option either macro or something else.

Please help,
Rgds,
Aligahk06

[Bob Phillips]

[vba]

With Activesheet

.Usedrange.Value = .Usedrange.value
End With
[/vba]