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.
Bookmarks