C
Charlie W
Thought I posted this question yesterday, but can't find it today. Please
excuse me if this becomes a duplicate post.
I'm trying to autofit text into a single-row merged cell. I wrote a macro
remarkably similar to the one referenced in this question. Both macros work
_most_ of the time. But, it appears that when the length of the text exceeds
some 'magic' value, neither macro works correctly. The problem seems to
occur when the length of the text is more that 400-500 characters. In those
cases, the merged cell gets resized, but not high enough to make all the text
visible.
Even if I place the same text into a single non-merged cell, the behavior
(and the flaw) is the same. The cell is resized, but the last few wrapped
lines of text are cut off. If I manually resize the cell, I can see all the
text. But if I then use the AutoFit function, the cell shrinks back down to
hide the last few lines of text.
Any ideas?
excuse me if this becomes a duplicate post.
I'm trying to autofit text into a single-row merged cell. I wrote a macro
remarkably similar to the one referenced in this question. Both macros work
_most_ of the time. But, it appears that when the length of the text exceeds
some 'magic' value, neither macro works correctly. The problem seems to
occur when the length of the text is more that 400-500 characters. In those
cases, the merged cell gets resized, but not high enough to make all the text
visible.
Even if I place the same text into a single non-merged cell, the behavior
(and the flaw) is the same. The cell is resized, but the last few wrapped
lines of text are cut off. If I manually resize the cell, I can see all the
text. But if I then use the AutoFit function, the cell shrinks back down to
hide the last few lines of text.
Any ideas?