VBA Autosize merged cells larger than max row height.

[BellyGas]

This is not a question, this is a solution to an issue I thought may be useful to anyone else trying to solve the issue with auto-size on merged cells. Normally, when you need to autosize a merged cell, the simple method is to unmerge the cell, autosize on the contents of the one cell and then merge the cell range again. However, if you have other merged cells or large value entries in other columns, this may cause issues. The main issue I'm solving here though is how to autosize a merged cell with a contents that autosizes to larger than the maximum 409.5 points.

In the example below, the sheet to be adjusted has large text entries in column F, each merged cell range is 10 rows deep. Hope this helps anyone having a similar problem.

Please Login or Register  to view this content.

[AliGW]

You've marked this as solved - is it?

[BellyGas]

As per the first sentence: This is not a question, this is a solution to an issue I thought may be useful to anyone else trying to solve the issue with auto-size on merged cells.

[AliGW]

In that case, it is in the wrong place - it should be in the Tips section. I shall move it for you.

[BellyGas]

Ta. Didn't know we had a tips section. Is that new?

[AliGW]

No - it has always been there.

[BellyGas]

Ah I see, the tips and tricks page is in the off topic section, no wonder I've never noticed it.