Forum Discussion
Copying the value of Comment into a cell
I have a large spreadsheet that I have to change to make it much more "user friendly" for folks who are not so familiar with Excel. This sheet has over 100 "comments" that I need to translate into r...
Sub commennt()
Dim i As Integer
For i = 1 To 10
Tabelle1.Cells(i, 2).Value = Tabelle1.Cells(i, 1).Comment.Text
Next i
End Sub
Maybe with this code if your comments are in cells A1:A10.