VBA to auto fit row height

I found this code on the forum to auto fit the row height using a group of merged cells. It works, but I want to try and modify it.

In this scenario on sheets 1, 2, and 3, D3:D6 are merged and A3:A6 are merged. Both contain variable amounts of text.

The range of merged cells the code looks at is D3:D6. Can make it also look at A3:A6 and use the cells that would give the larger row height?

I also need to automatically adjust the page breaks so they do not fall in a merged cell.

If anyone has a better formatting idea to do what I am doing let me hear it.

I am new to VBA and appreciate any assistance.

Please Login or Register  to view this content.