Need macro to autofit height for merged cells

[Guest]

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?

 

[Norman Jones]

Hi Fishman123,

See this macro from Jim Rech:

http://tinyurl.com/4c5l6