Share via

Extracting Comments from multiple cells in Excel

Anonymous
2019-12-05T13:56:13+00:00

hi, I need to extract comments from multiple cells in Excel. I tried several VBA codes from google, but don't help. I use Excel from Office 365. 

Please assist me as I have about 300 cells with comments. Copy and paste is not feasible. 

H

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-12-05T14:08:37+00:00

    Hi. Habit's

    I'm Robert, an Independent Advisor trying to help.

    In that case, first, we can try this method:

    Sub Export Comments2 ()

    Dim COMMENT As Comment

    Open ThisWorkbook.Path & "\ Test.txt" For Output As # 1

    For Each COMMENT In ActiveSheet.Comments

    Print # 1, COMMENT.Parent.Address (False, False) & ":" & COMMENT.Text

    Next COMMENT

    Close # 1

    End Sub

    This serves to extend the comments in txt files. If this were your case!

    Regards,

    Robert.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-12-05T14:20:25+00:00

    Hi Robert, thank you for your consideration. I have inserted the script in the macros. I am not getting results. Is it OK I send you the file you assist?

    Was this answer helpful?

    0 comments