Excel 2003 comments - When a column is moved or columns are insert

[Guest]

comments do not move with the cell they were created on and has long pointers
to them in the worksheet. They are stationary and not floating with the cell
if moved. So the comment may be several pages away from its intended
location. Any suggestions?

 

[Dave Peterson]

Put them back where they belong with a macro???

From Debra Dalgleish's site:
http://www.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