AutoSize a cell comment

[XP]

Using Office 2007 and win XP;

I need example VBA code that auto sizes a cell comment in the activecell.

I tried recording, but the recorded code doesn't work.

Any chance someone could post something like that?

Thanks much in advance.

 

[Dave Peterson]

Maybe the code at Debra Dalgleish's site will give you a start:
http://contextures.com/xlcomments03.html#Resize