The automatic sizing feature in Autoshape formatting seems buggy to me.
I'm using Excel XP, and when I auto size, it resizes the shape so that
all the text is on one line.

I would like to keep the width of the shape the same, but adjust the
height based on the length of the text. Anyone got any ideas on how I
can do this in VBA?

Thanks,
Nick