I would like a code to to covert a range of cells in a column to convert to comments. Also, when i update the text in a cell i would like it to change what is in the comment. I do not want the text to show up in the cell because i do not want it to change the size of the cell. If, however, you are able to develop the code to insert and update the text into a comment and allow the cell text to be visible without changing the size of the cell if there is too much content then that will be fine with me as well.
thank you
Bookmarks