Converting Comments

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert From Comment to Cell Content 1
Move comment into cell as text 4
Word to Excel: Export comments with text and line number 0
Text to Rows 2
Can Comments be automatically converted to text cell values? 1
keeping leading 0's when formatting cells 3
contents of cells to rows 6
insert comment 2

Top