I can't figure this out for the life of me... even manually in Excel, so that I can sick "Macro Recorder" on it.
How can you copy or get the content ("custom formatted
text") of an Excel (2007) cell comment
out, and paste it into a cell as a cell's content (again, "formatted
Solutions accepted manually or programmatically.
Ultimately, I need to turn this into VBA. Right not I'm using something similar to the "showcomments" function here:
I have figured out how to copy and paste a whole comment as in...
Dim rngSource As Range
Dim rngTarget As Range
Set rngSource = ...
Set rngTarget = ...
...but not how to get the comment (and it's formatting) out.