MWE
10-26-2006, 12:06 PM
this may seem pretty lame, but ...
When a cell contains more text than can be displayed for the current row height and word wrap is on for that cell, one can normally just select the row and double click on the lower edge of the row number and the row height will adjust to nicely display the contents of all cells in that row. The row height seems to be biased toward printing vs viewing on the screen, but that is minor. But the basic process does not work all the time. For some reason I do not understand, there are times when the only way to change the row height is to do it manually. None of the automatic features seem to work. :banghead:
Similarly, when VBA tries to automatically adjust row height for what ever is in that row, it works if it would have worked manually. But if it would not have worked manually, it does not work under VBA control.
What is going on here? :dunno Is there some cell or row property (perhaps something called PITA) the does not allow automatic adjustment of row height. I have not seen this problem with col width, but I use that much less frequently.
Thanks
When a cell contains more text than can be displayed for the current row height and word wrap is on for that cell, one can normally just select the row and double click on the lower edge of the row number and the row height will adjust to nicely display the contents of all cells in that row. The row height seems to be biased toward printing vs viewing on the screen, but that is minor. But the basic process does not work all the time. For some reason I do not understand, there are times when the only way to change the row height is to do it manually. None of the automatic features seem to work. :banghead:
Similarly, when VBA tries to automatically adjust row height for what ever is in that row, it works if it would have worked manually. But if it would not have worked manually, it does not work under VBA control.
What is going on here? :dunno Is there some cell or row property (perhaps something called PITA) the does not allow automatic adjustment of row height. I have not seen this problem with col width, but I use that much less frequently.
Thanks