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.

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

XP wrote:
>
> 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