Auto Adjust Row Height based on Wrapped Text Sentences

[nhinx]

Dear Excel Experts,

I tried the code below to automatically adjust the row height in merged cell from A10 to G10. For example, if my sentence is justified in 2 lines only the row height will adjust for 2 liner sentences. Then if my write ups could go longer (example: 6 lines sentences) it should also adjust based on that data.

Range("A10:G10").EntireRow.AutoFit
Range("A10:G10").WrapText = True

However, the code doesn't seems to work.

Can you help me resolve this problem?

Thanks,
Nhinx

 

[oldbrewer]

I found after setting wrap text on cells A1 to A3 as I added text the row height increased and when I deleted some of the text the row height automatically adjusted

 

[nhinx]

Hi Oldbrewer,

That is possible if your cells are not merged. But for the merged cells, you need a vba code to do that.

 

[Fluff]

I'll start again

 

[Fluff]

Hia
Take a look at this
blog.contextures.com/archives/2012/06/07/autofit-merged-cell-row-height/

HTH

 

[JLGWhiz]

You need to unmerge your cells then remerge them to get autofit to work. This directly from MS

In Excel, you cannot use the AutoFit feature on a column that contains a cell merged with cells in other columns. Likewise, you cannot use AutoFit on a row that contains a cell merged with cells in other rows.

Merged cells are schitzo.

 

[Rick Rothstein]

Hia
Take a look at this
blog.contextures.com/archives/2012/06/07/autofit-merged-cell-row-height/

HTH

I get a "Page Not Found" notice for that link.

 

[Fluff]

I get a "Page Not Found" notice for that link.

Rats. in my initial attempt the link worked but the text kept changing to "403 Forbidden"
Have a look here
HTH

 

[Rick Rothstein]

Rats. in my initial attempt the link worked but the text kept changing to "403 Forbidden"
Have a look here
HTH

That link works... thanks.

 

[Fluff]

That link works... thanks.

No problem