try
Function Comment(MyCell)
Comment = MyCell.Comment.text
End Function


"BillyJ" wrote:

I'm trying to create a fucntion that references the comment in a cell. Below
is what I have but it's obviously flawed somehow but dont know how to fix it.
Any help? Many thanks in advance.

Function Comment(MyCell)
Comment = MyCell.Comments
End Function