Adding Record to data table + preserve array formulas in specific columns

Hi, I have an excel Table with 14 columns. Columns 1 to 5 contain numerical values. Columns 6 to 14 contain array formula. The numerical values in columns 1 to 5 are fed to the array formulas in the other columns.

I have a userform with which users can create new "Records" (i.e. rows) in the data Table.
Users input 5 numerical values in the userform (value1 to value5) which are then added to the data Table with the following:

Please Login or Register  to view this content.

The code above works like a charm for adding the values to the Table BUT it also replaces/overwrites the array formulas in Columns 6 to 14 with blanks.

Is there a way to use the ".ListRows.Add.Range" statement (or other statements) while preserving the array formulas in the other columns? Objective is to have Columns 1 to 5 filled with Values 1 to 5 but to keep the formulas in Columns 6 to 14.

I tried:

Please Login or Register  to view this content.

but it does not work.

Any help would be greatly appreciated.

Seems like i found a way to make it work. Might not be super clean/efficient but at least it works...

Please Login or Register  to view this content.