ashish koul
Member
If you want to extract the comment from a cell. Try this UDF-
[pre]
[/pre]
[pre]
Code:
Function extract_comment(cmt_rng As Range) As String
If Not cmt_rng.Comment Is Nothing Then
extract_comment = cmt_rng.Comment.Text
Else
extract_comment = "No Comment Found"
End If
End Function