Paste selected cell value as comment without overwriting existing comment

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!