Autofit height of merged cells

[Renee_KK]

Hi there
Does anyone know how to autofit height of merged cells please?
Many thanks
Renee

 

[JLGWhiz]

If you mean in VBA, then I would think that

ActiveSheet.Rows(1).Autofit

would work. You have to do the whole row, but it does autofit vertically.

 

[Ken Cowen]

Renee
You can't auto fit the row height of merged cells.
When I have columns merged, which I try very hard to avoid, but sometimes on forms it is the only way to go, I will have column to the right that is the same width as the total width of the merged columns . In that column will be a formula that picks up the value in the merged columns and that cell will be set to auto row height, making the row the appropriate height for the merged columns. The best solution, by far is not to merge cells.
I hope this helps.
Ken

 

[JLGWhiz]

Renee
You can't auto fit the row height of merged cells.
When I have columns merged, which I try very hard to avoid, but sometimes on forms it is the only way to go, I will have column to the right that is the same width as the total width of the merged columns . In that column will be a formula that picks up the value in the merged columns and that cell will be set to auto row height, making the row the appropriate height for the merged columns. The best solution, by far is not to merge cells.
I hope this helps.
Ken

Amen to the avoid merging.