Filtering cells with comments

[LeighC]

Hi there! Hope someone can help me with my problem. I have a large spreadsheet with over 3,000 rows of data and I have marked each with a specific action required in column D. However, I also attached some comments to the cells in the actions column and I would now like to filter out these cells so I can follow them up. I have tried Autofilter and Advanced Filter and read through most of the Help guide but can't find anything to help me do this. Can you filter to show only those cells in a column with a comment attached? Any help would be greatly appreciated!

 

[sadams1]

hello again! Greatly appreciate the code...when it's run, it returns "type mismatch line 13" which is the column designated.

 

[Rick Rothstein]

hello again! Greatly appreciate the code...when it's run, it returns "type mismatch line 13" which is the column designated.

Who is this comment meant for? It doesn't appear to be mine as my code has less than 13 lines in it.

 

[sadams1]

hello Rick...sorry for the confusion! I run the code but it's not picking up the manually highlighted in yellow cells. Again, I greatly appreciate your time messing with this.

 

[Rick Rothstein]

hello Rick...sorry for the confusion! I run the code but it's not picking up the manually highlighted in yellow cells. Again, I greatly appreciate your time messing with this.

Are your yellow cells in Column A?

What color is your yellow? To find out, select a yellow cell, run the following line of code in the Immediate Window and post the number that is printed out...

? ActiveCell.Interior.Color