Converting Comments
 

How do I convert comment text to a seperate column cell as text data?

"Sarah" wrote:

How do I convert comment text to a seperate column cell as text data?

Assuming you have a comment in cells A1 to A10 use this macro to copy the
comments into B1:B10

Sub CopyComments()
On Error Resume Next
For a = 1 To 10
Cells(a, 2) = Cells(a, 1).Comment.Text
Next a
End Sub