G Guest May 26, 2005 #2 Sarah said: How do I convert comment text to a seperate column cell as text data? Click to expand... 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
Sarah said: How do I convert comment text to a seperate column cell as text data? Click to expand... 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
