"Gary''s Student" wrote:

Use this small User Defined Function:

Public Function whatsInIt(r As Range) As String
whatsInIt = r.Formula
End Function


Thanx! This was very helpfull! Works great! But to use this as an argument
in another function I need it without the equal sign. I can't use the
textfunction RIGHT() since it will convert to a textstring. Any idea?

Regards,
Khai N.