Resizing Multiple Comments

[holliday50]

I have a spreadsheet with over 1000 rows, with comments in 1 cell in each row. The problem is that the comment box is too small, and cuts off part of the verbiage. How can I resize all of them at once, so that everything in the comment field is visible?

 

[vatra]

I just read the entire thread. I don't know VBA. Can someone help me form the code to achieve the following:

1. Resize comment to fit the text
2. Glue comment to the parent cell
3. Define comment offset from the parent cell (I like the default Excel offset)
4. Define comment font (Tahoma 8 Regular)
5. Do all of this in a single run, without debugging windows, steps, and confirmation boxes.

Regarding comment offset: Is it possible to fine-tweak the offset position, by pixels for example? I saw in the previous solutions that the offset unit was a cell.