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?
I tried to duplicate your problem but was not successful. Can you post a sample workbook?
Peace of mind is found in some of the strangest places.
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.
Hmm...
this time it worked. Have to find out what is the difference. Thanx so far.
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.
Peace of mind is found in some of the strangest places.
As you said, I don't know how
Yes, please mark this one as solved.
Posting Permissions
Reply With Quote
