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


    Regards,

    Hari

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


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

    Rory
    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!