Quote:
Originally Posted by JBeaucaire
A FUNCTION() is by definition a formula. If it is used in a cell, that is.
However a macro can be invoked to run on the activecell. This macro will convert the current selected cells into flat values:
Code:
Sub RemoveFormulas()
Selection.Value = Selection.Value
End Sub
|
in below function by giving =sss(a1) in formula bar it well get font size of user
Public Function sss(strCell) As String
sss=strCell.
Font.Size
End Function
like that only i need, if i give =sss(a1) remove formula and give flat value