Autosizing labels Excel 97

S

Striker475

I am looking to have a label or text box autosize both horizontally and
vertically when a large amount of text is inserted. I have had no
problems getting it working horizontally - the vertical is the problem,
as quite often it just lops the bottom of a section of text. Can anyone
help?
 
S

Striker475

Just a note: This would also work with a textbox, but I need it so that
it doesn't autosize past column I on default size so that it doesn't
spread horizontally and mess up on printing.
 
Top