Forum Discussion
Row adjust not working for merged cells
I am using MS 365 v2102 There is a merged cell that will contain a long text. Typically used for notes. When I touch "wrap text", the merged cell with long text only shows one line. I manual...
Does your text contain the line feeds (Alt/Enter or CHAR(10)) or are you relying on the cell width to generate the now line?
I find that, with dynamic arrays, merged cells trouble me less. My source data would be held in Tables and the calculated values are all dynamic arrays. I have very little need to make manual selections in regions outside these named objects, so I do not come into conflict with the merged cells to any great extent. One use I have for merged cells, is to display the result of FORMULATEXT which, these days, may well run over 10 or more rows when using combinations of LAMBDA and LET.
Merged cells cause a lot of problems in Excel VBA. One can work around them, but it's a pain in the behind... 😞