AutoFitHeight not working

T

Ted Lawson

I tried to use the AutoFitHeight="1" attribute in the Row element of my excel sheet. But the characters in the last row of each cell are cutting down. I have to manually adjust the row height after the whole excel file is generated which is very tedious.

I have already removed the Height and the DefaultHeight attributes. Can anyone help please?
 
A

Alan Moseley

I must be missing something. I do not see the AutoFitHeight method in my
version of Excel (2003)

To get my rows to automatically size I use the AutoFit method, e.g. to
automatically size rows 1 through 5 on the active worksheet I use:-

ActiveSheet.Rows("1:5").AutoFit

Does this help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SpreadsheetML AutoFitHeight 0
Find Hidden Value in word tables cells 0
Remove Identical words 0
AutoFitHeight and Height not working together 0
AutoFitMergedCellRowHeight limitation 0
Auto Row Height Protected Template 1
Excel autofit row height not working 0
Auto-adjust row height does not work correctly 2

Top