Hi guys,
I am using VBA in Excel with imported data, can anyone tell me why this code won't work:
Sub Test()
Dim mycomment As String
mycomment = Range("a1")
Range("a1").Comment.Text.mycomment
End Sub
I want it to show the contents of a cell in a comments box. Any help would be most appreciated?