Paste selected cell value as comment without overwriting existing comment

  • Hi - For selected cells, i need VBA code which copies cell values and paste it as comment. If existing cell comment is there, it should not overwrite it

  • Try this


  • I've re-read the question and I think this is what you mean.


  • First code is helpful..only scenario it doesn't work is


    1) if there is no existing cell comment then it doesn't add cell value in the comment. example if cell A1 has calculated value as 45 but currently no comment, macro doesnt do anything. I need this macro also to add 45 as cell comment.


    2) if cell comment can be added on top of existing comment. currently it adds below existing comment.


    thanks so much for help.

  • Try this