VBA code to autofit row height based on text and to break page at certain row

[YingFa]

Hi,

I have a document that has merged cells and therefore this cannot autofit the row height based on the text. Is there any VBA code that allows to autofit the row height based on text and also to do a page break at certain row all the time?

Thank you.

 

[Logit]

Merged Cells will haunt you forever. Get rid of them and redesign your worksheet.

 

[YingFa]

Merged Cells will haunt you forever. Get rid of them and redesign your worksheet.

Thank you but not always possible.

 

[GWteB]

Why not?

Book1
	A	B	C	D	E
1	zzzzzzz
2
Sheet1