Need macro to autofit height for merged cells

F

FishMan123

I often create spreadsheets where cells contain wrapped text. The ability
for a row to automatically adjust height to accomodate the amount of text is
great. BUT it doesn't work if the text is contained in merged cells.

Is there any way to determine the appropriate row height needed to fit the
given text?

Example: Merge cells A1 and B1. Set justification to left and text to
wrap. Type a bunch of text. Autofit doesn't work for merged cells. How can
I adjust the text to the apropriate height with a VB macro?
 

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