I want to copy "Comments" from one sheet to another, but all of the comments are actually Pictures.
So far, the below works for text - and I tried changing to: rgCELL.Comment.Picture .... but that didn't work.
Public Function CELCOM(rgCELL As Range) As String
On Error GoTo NO_COMMENT
CELCOM = "Comment in " & _
rgCELL.Address(False, False) & _
":= " & _
rgCELL.Comment.Text
NO_COMMENT:
End Function
Is there another way to get the picture comments to copy over?
Bookmarks