VBA for autofit

[Johfra]

I have been searching online and I keep finding that it some cases, it works, in others it is not recommended.

I have a spreadsheet with many different information that requires specific row size but I have one row where the information could exceed its given space....where the autofit is needed.

I have tried many VBAs but none really worked. I am still new to this, though I love to learn more and eventually understand what the codes actually mean.

Am I dreaming too big or can this actually be done?

Thanks.

 

[muckshifter]

please, one post on the same subject is sufficient.

https://www.pcreview.co.uk/forums/vba-autofit-merged-rows-t4058601.html