Hi, I cleared the code from the worksheet in question and pasted in what you provided. I can see that it's doing something, but it doesn't seem to be operating as intended. The row height was set to 15 (20 pixels) regardless of how much content I entered. I did play with changing "15" to another value and can see the effect, but it continues to set the row height to the new value every time.

I might just be misunderstanding. I can see that the code assigns different row heights to "Case 1 To 100", "Case 101 To 250" and "Case 1100 To 1200", but I guess I don't understand what that's referring to. It doesn't seem to refer to the amount of content entered (as I got the same row height regardless of whether I entered a little or a ton) or the combined width of the merged columns (as I played with those and saw no change).

Thanks again for your help!