Need macro to autofit height for merged cells
 

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?

Need macro to autofit height for merged cells
 

Hi Fishman123,

See this macro from Jim Rech:

http://tinyurl.com/4c5l6


---
Regards,
Norman



"FishMan123" wrote in message
...
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?