PDA

View Full Version : Solved: AutoFit rows



CptGreenwood
10-24-2005, 06:07 AM
I have a cell which can contain severals lines of text (seperated with Alt+Enter). After finish typing I want to set the row high to optimal by using "AutoFit". Unfortunately after that the row is sized that only 10 lines of text are visible, the ramaining 3 lines are covered. Why doesn't AutoFit work as it is said in the help files? Has it any kind of restriction?

austenr
10-24-2005, 06:21 AM
I tried to duplicate your problem but was not successful. Can you post a sample workbook?

ALe
10-24-2005, 06:30 AM
There must be something in your workbook because the autofit method has no problem to show 13 lines on my PC both via Excel and via VBA.

CptGreenwood
10-24-2005, 06:55 AM
Hmm...
this time it worked. Have to find out what is the difference. Thanx so far.

austenr
10-24-2005, 08:04 AM
Is this post solved? If so please mark it so or let us know and we will close it for you if you don't know how. :hi:

CptGreenwood
10-24-2005, 08:07 AM
As you said, I don't know how :whistle:
Yes, please mark this one as solved.