Comments and Sorting
 

Hi,

I have a number of cells that have visible Comments.

When a macro of mine sorts - the comments seem to stay where the cell
was originally. I'd like the comments to be branched off near where
the cell is located after my sorts complete.

Is there a way to do this?

Thanks in advance.


--
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
 

I can´t reproduce your error. When I have comments in the cells
visible or not, they stick to the number they are with, regardless o
the order

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=27650

Comments and Sorting
 

Maybe you could just put them where they belong after the sort:

http://www.contextures.com/xlcomments03.html#Reset

strataguru wrote:

Hi,

I have a number of cells that have visible Comments.

When a macro of mine sorts - the comments seem to stay where the cell
was originally. I'd like the comments to be branched off near where
the cell is located after my sorts complete.

Is there a way to do this?

Thanks in advance.

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

--

Dave Peterson