Automatic height adjustment of merged cells across worksheet

[Clair2004]

Hi All

I have looked a previous threads and not quite got there. I have a worksheet with various merged cell ( yes I have tried to avoid them but the text needs to be left justified so Centre across selection doesnt work) In the end I think I need some code to place into a worksheet which would autofit height for merged cells. I hope this makes sense. Thanks in advance

C

 

[EFANYoutube]

I can't quite make out exactly what you want but hope this is Clair enough for you

This changes row height regardless of merges but you can cover many cells by changeing the rows() numbers

ThisWorkbook.Sheets("Sheet1").Rows("1:2").RowHeight = 10

 

[shg]

Suppose A1:B1 are merged and contain wrapped text. Then make column C (or any unused column) the combined width of columns A and B, and in C1, enter =A1 and format to wrap text and use the same font as A1:B1. Then autofit row height.

That works, but my first suggestion would be to try harder to avoid merged cells.