Want to insert cell value in Comment

  • Hi All,

    Thanks for your response in advance.

    I am facing an issue while adding cell value in comment. I have an excel sheet which have two column A and B. Column B have the value which i want to put in comment.

    When i run my macro code it is adding a comment but its not taking the adjacent cell value in comment. Can you please help me in this

    I attached the file for your reference



  • You didn't specify the text for the comment. You need:

    cell.Offset(0, -1).AddComment cell.Value

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

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