AutoFitMergedCellRowHeight limitation

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top