Copying of cell text from one file to paste as cell comments in a
Try
Sub CreateComm()
Dim commText As String
commText = ActiveCell.Value
With Range("A10") 'change as required
.AddComment
.Comment.Visible = False
.Comment.Text Text:="" & commText
End With
End Sub
Regards
Rowan
"Wayne" wrote:
I would like to get the text in a cell in one file and
paste that text as comments to a second cell in another
file. Have tried a number of things but no luck!!
Wayne
|