Macro to Auto Fit Merge Row Height

[earthworm]

I have a merged row . One of the row height is extended to the fullest . but due to size of the content , I have to merge the second row so that I can also increase height of second row to some height to display the content completely .

I need a macro that can auto fit the row height based on content . Please note that the merge rows will always be 2 rows . however this will repeat below to some other rows

example

Book3
	C	D
2	Row 1	MERGED
3	Row 2
4	Row 3
5	Row 4
6	Row 5
7	Row 6	MERGED
8	Row 7
9	Row 8
10	Row 9
11	Row 10
12	Row 11
13	Row 12	MERGED
14	Row 13
15	Row 14
16	Row 15	MERGED
17	Row 16
Sheet1

 

[earthworm]

Bump!

 

[Skyybot]

Is there a reason that the rows are Merged besides needing the height? If not, you can simply format Column to Auto-Fit Row Height instead of Merging.

 

[earthworm]

Is there a reason that the rows are Merged besides needing the height? If not, you can simply format Column to Auto-Fit Row Height instead of Merging.

Yes the content in cell is allign in such wa way that I cannot make it fit in one row.
It's requirement