C
Charlie W
I developed a macro similar to the AutoFitMergedCellRowHeight code I found on
this Forum. But operate on a single row, but both seem to suffer from the
same limitation: It appears that AutoFit Row Height only adjusts a Row
height up to about 11 or 12 standard row heights. When the amount of text in
a merged cell requires the cell to be resized to a height larger than 11 or
12 standard rows high, the built-in resize function seems to be unable to
resize the text so that it is all visible.
This seems to be true for the mergedcell macro as well as for single cells
with the Wrap attribute set.
In either case, I can resize the Row manually to make all the text visible.
But the autofit feature always shrinks the cell height back down to the 11-12
high size.
Is there a solution for this?
this Forum. But operate on a single row, but both seem to suffer from the
same limitation: It appears that AutoFit Row Height only adjusts a Row
height up to about 11 or 12 standard row heights. When the amount of text in
a merged cell requires the cell to be resized to a height larger than 11 or
12 standard rows high, the built-in resize function seems to be unable to
resize the text so that it is all visible.
This seems to be true for the mergedcell macro as well as for single cells
with the Wrap attribute set.
In either case, I can resize the Row manually to make all the text visible.
But the autofit feature always shrinks the cell height back down to the 11-12
high size.
Is there a solution for this?