Not sure what you're describing or expecting for a solution but maybe
re-position Comments to default?

This from Debra Dalgleish.


Reset Comments to Original Position
If comments have moved out of position, you can reset them using the following
code:


Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub


Gord Dibben MS Excel MVP


On Thu, 26 Jun 2008 17:08:53 -0700, "Richard" wrote:

I have several thousand rows and some cells have comments in them and every
time I edit anything it drop or raises all my comments, I have Excel 2002,
what can I do about
this?

Richard