Comment
 

Is it possible using function or formula to "read" and use the contents of
a comment ?

AFAIK there is no built in function to do this, but theres always vba.
Press Alt+F11 and paste this in a module:
Public Function ShowComment(Rng As Range)
ShowComment = Rng.Comment.Text
End Function

Then you can use it like any ordinary function.
Like this: =ShowComment(A1)


Per Erik

On Sat, 16 Jul 2005 17:11:03 GMT, "Phil"
wrote:

Is it possible using function or formula to "read" and use the contents of
a comment ?