How to check if a cell have a comment

[FJAY]

Good Afternoon - I have a worksheet and I will like to autosize all the cells with comments. The code below works if the used range all have comments.

ActiveCell.Comment.Shape.TextFrame.AutoSize = True

 

[Dreamboat]

Try this FJAY:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=101

Excel VBA Certification is Finally Here!

http://www.vbaexpress.com/forum

Check out this bar:

http://www.ArtBarFtLauderdale.com