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?
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.