Automatic row height after text entered into wrapped and merged cells

Guys

Hope you can help? This is probably an easy one but I just can't crack it!!

I am in the process of constructing a report for work where I have merged a set of 5 cells in a row and wrapped the text. I have then linked it to my Word document with no issue, very straightforward etc etc, however, I cannot work out how to get the row in question to automatically adjust its height to accommodate and display a great deal of text. I do not want the end user to have to go into the Format > Autofit Row Height function every time new data is added, do I need to write a macro for this and if so can anyone help or provide assistance??

Thanks in advance,

Steve

Have you tested

ActiveSheet.UsedRange.Rows.AutoFit

Alf