You need a UDF (User Defined Function). Copy the UDF below...
'/=======================================/
Public Function Comment(rng As Range)
'rng must point to a single cell
'Get Text in a comment of one (1) cell
Application.Volatile

On Error GoTo err_Function

Comment = rng.Comment.Text

exit_Function:
On Error Resume Next
Exit Function

err_Function:
GoTo exit_Function

End Function
'/=======================================/
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Pete at Sappi Fine Paper" wrote:

How do I make one cell equal to the comment in another cell? One would think
that =comment(A1) would do it, but of course it doesn't. Can anyone help?