Comments and Sorting
 

Hmmmmm, I don't think this is an error situation ..... I think that I
just need to be manually keeping the Comments near the cells after the
sort takes place (or maybe it's an option within .Sort ?

For example - let's say I have a range from row 1, column 1 to row 100
to column 50. If 20 cells in column 10 randomly between row 1 to 100
have Comments - when I do the Sort - the comments don't stay near the
cells (as the sort moves the rows to different areas depending on the
sort). So it ends up looking messy as there are lines stretched across
the screen from the cells to their comment boxes. I just want to keep
the comment boxes near their cells following the sort.

Does that help?


--
strataguru
------------------------------------------------------------------------
strataguru's Profile: http://www.excelforum.com/member.php...fo&userid=1313
View this thread: http://www.excelforum.com/showthread...hreadid=276502

Comments and Sorting
 

In normal operation a comment's "shape" should have "move and size"
with cell to work as expected by OP.


Note that you can easily click "set as default".. in the right click
menu of a comment. If you do that on a comment that's manually sized..
ALL your future comments will behave "unexpectedly"






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


strataguru wrote :


Hmmmmm, I don't think this is an error situation ..... I think that I
just need to be manually keeping the Comments near the cells after the
sort takes place (or maybe it's an option within .Sort ?

For example - let's say I have a range from row 1, column 1 to row 100
to column 50. If 20 cells in column 10 randomly between row 1 to 100
have Comments - when I do the Sort - the comments don't stay near the
cells (as the sort moves the rows to different areas depending on the
sort). So it ends up looking messy as there are lines stretched
across the screen from the cells to their comment boxes. I just want
to keep the comment boxes near their cells following the sort.

Does that help?