Does this happen with any new Comment you insert in any cell?

I can't explain that but you can reset to the proper position.

See Debra's site for a macro.

http://www.contextures.on.ca/xlcomments03.html#Reset


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 04:30:01 -0700, S.Kumar
wrote:

if i insert a comment in cell number D1110 the comment is not displaying near
that cell number, it displays in top of the row means row number 1, please
help to rectify it