Has anybody written a macro that will set the correct row
height to display all of the text in horizontally merged
cells in a single row? The problem arises if you merge
(say) 4 cells and then enter text which is greater than
the width of those cells and select wrap text.
The "excess" text disappears from view, but reappears
properly wrapped if you double the row height. So the
macro needs to know the size of the entered text and the
width of the merged cells and could then presumably
adjust the row height accordingly.
Or is there another way? Unfortunately text boxes are of
no use in the application I need this for.
Many thanks in advance to any helpers.
MBK