Make us MS Excel related C-Sharp code to resize arrays.

I have an UDF in Excel using Add-in Express.

Write, test and provide us with a ready to use CS code that:
When the UDF is receiving new data from the RTD server and the array dimensions are changed, make sure that the array in Excel resizes without the need of the user to press anything such as ‘ctrl-shift-enter’.
This has to work from Excel 2010 (that does not support dynamic arrays) up to Excel 2021 and 365 (that supports dynamic arrays).