Debra Dalgleish shows how:
http://contextures.com/xlcomments03.html#Reset

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

katharina wrote:

Hi, by inserting and deleting columns the comments appear far away of the
cells they belong to. Is there a way to re-arrange without having to move
every single comment? Thanks beforehand, katharina

--

Dave Peterson