Comments - stop resizing and moving comments
When hiding and un-hiding rows, or moving rows, or having freeze panes on, the comments on cells for no reason stretch or move far down one's sheet. It would be really nice if the size of the comment stays as is and it doesn't move all over.
Jan Wx, NZ commented
Very clever Col, but it shouldn't be needed in the first place :)
For now I'll take your lead though as I doubt this will be fixed soon
Col Delane commented
This is absolutely necessary if you use Autofilters or Grouping.
I have adapted VBA code [ posted by Faith Granger on http://www.mrexcel.com/forum/excel-questions/796938-macro-put-all-comments-back-where-they-belong.html ] to auto-size and relocate cell comments on the active sheet or entire workbook (user choice of scope)