aligahk06
03-31-2010, 04:40 AM
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
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