Formula to value a click .

Formula to value a click .Here use a small Vb code when we copy something then paste another sheet problem face by this formula cell another way some time we face which formula use this are hide this are difficult but everything solve by click because all

formula cell to value and tension free.
Vb code are :

Sub All_cell_formula_delete()
    With ActiveSheet.UsedRange
        .Value = .Value
    End With
End Sub
'To use this UDF push Alt+F11 and go Insert>Module and paste in the code. Push Alt+Q and save. 
'by Md. Shaiful Islam Talukder .

Download the workbook

Tweet