S
strataguru
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?
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?