Searching for text within formula
hi,
i'm not sure if my understanding is correct for your request,
Sub test()
MsgBox SearchFormula(Range("A1"))
End Sub
Function SearchFormula(rng As Range) As String
x = Split(rng.Formula, Chr(34))
SearchFormula = x(1)
End Function
--
isabelle
|