Hello all,
I have a worksheet in a large workbook that compiles results into one row (with cells A1:K1 pre-merged). The amount of text that is compiled will always vary, and will often exceed the max row height. Is there a way to have code detect the total height of the text and automatically merge the correct number of rows, while maxing out the height of those merged rows as needed, to display all of the text correctly? The end goal is one large completely visible cell that the user can copy the text from and paste into another program. Thank you for any help you can give!
Bookmarks