Hello!
I would like the contents of a cell to be inserted as a comment. Now I've seen a few examples that work, but they only work on selection or for a single cell.
These are the cell ranges that have information that I want to have inserted as a comment in the same cell. C5:AG5, C10:AG10, C15:AG15 and so on, all the way up to C170:AG170.
I'd like for it to automatically search for any cells(in specified range above) that have been changed(worksheet wide) and add it to the comments. However empty cells are not to be commented.
Was hoping any of you have some example code laying around that could make this work or at least point me in the right direction.
Added a example workbook in case it's not clear, no code included.
Any help is much appreciated, thank you in advance.
Bookmarks