row height

[Tom George]

Does anyone know how to make the rows.autofit to go beyond 255 pixels? I
have text that is larger than the 255 pixels and excel cannot go beyond that
in my vba code.

Thanks,
Tom

 

[Dave Peterson]

You may want to add some alt-enters (every 80-100 characters) to that cell with
the long text. Then try autofitting the rowheight manually. If it works, then
the .autofit should work fine in code, too.

Or if you know how large that rowheight should be, maybe you could just manually
adjust it:

ActiveSheet.Rows(1).RowHeight = 409