Comments Export

[mouthpiec]

Hi,
Is there any function that export the comment of a particular cell t
another cell?

thanks in advance
sandr

 

[Frank Kabel]

Hi
have a look at
'Edit - Paste Special - comments'

 

[286pc]

Hi
try the following macro:
Function returnComment(sourceRange As Range) As Variant

Dim sComment As String

Application.Volatile

On Error Resume Next
sComment = sourceRange.Range("A1").Comment.Text

If Err <> 0 Then
returnComment = CVErr(xlErrNA)
Else
returnComment = sComment
End If

End Function



http://blog.naver.com/excelmaster.do
http://cafe.naver.com/excelmaster.cafe