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.