Macro to adjust cell heights with wrapped text

[Jest]

Hey Excel enthusiasts! I need some advice on creating a macro. I have an Excel sheet filled, and it's a bit messy with merged and centered cells. Some columns and rows are merged and centered, and I want to tidy it up by adjusting the cell heights to match the wrapped text.

I've scoured the internet for Visual Basic code that fits my needs, but none seem to do the trick. Does anyone have a suggestion or a working macro that could help me out? Your expertise would be greatly appreciated!

Thanks in advance for any assistance you can provide!

 

[WhoCanDo]

Isn't that just a formatting control?

Tick Shrink to fit and maybe Wrap text.

If you don't want to use Wrap text, then alt-Enter will wrap the text where you want it while you are typing it in.

 

[Jest]

Hi WhoCanDo

Thank you for looking into this. I was really hoping for a quick fix, but it seems like the task box is grayed out, preventing me from checking it. I've attached a screenshot and description of what the document looks like for your reference. If you have any further suggestions or if I'm missing something obvious, please let me know. Your advice is greatly appreciated.