Comment move after sorting, help

Patthe

New Member
Joined
Nov 29, 2016
Messages
2
Hi,
So I have a excel sheet with lots of data and information and comment in the cell.
I use filter a lots. My problem is when I filter the comment don't follow, they stay at the location the comment was first created.

I do have a macro that I activate by pressing ctrl+A, that move the comment next to cell where they should be.
My problem is that every single time I use filter I need to re-run the macro.

Is there a way to have a macro or a way that those comment always stay same spot, next to where they where create? Follow the box no matter what the filter it?

Thanks
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Patthe, why don't you move those comments by a macro? The following code works like "resetting" the location of comments on the worksheet.

Code:
Sub MoveComments()
    Const coef As Long = 5
    Dim objCmt As Comment
    For Each objCmt In ActiveSheet.Comments
        objCmt.Shape.Top = objCmt.Parent.Top + coef
        objCmt.Shape.Left = objCmt.Parent.Offset(0, 1).Left + coef
    Next
End Sub
 
Upvote 0
Patthe, why don't you move those comments by a macro? The following code works like "resetting" the location of comments on the worksheet.

Code:
Sub MoveComments()
    Const coef As Long = 5
    Dim objCmt As Comment
    For Each objCmt In ActiveSheet.Comments
        objCmt.Shape.Top = objCmt.Parent.Top + coef
        objCmt.Shape.Left = objCmt.Parent.Offset(0, 1).Left + coef
    Next
End Sub

Good day,
I change my that code to fix the comment.
But the problem still there.
If by example:

A1 to A26 : A to Z

I add comment to A10 ( letter J )
Then I add a filter and want only J to show up..
when I want to edit the comment, the bubble is all the way down, where J was initially.

you know what I mean ? How can I do something that no mater what filter I have, the comment is always at the same location ?
 
Upvote 0

Forum statistics

Threads
1,213,582
Messages
6,114,470
Members
448,574
Latest member
bestresearch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top