Yes that works. I presume because your formula uses sheet references rather then table references.
I started using tables because they seemed to provide benefits over ranges such as auto formula change for columns, column sorting and such. I therefore have always tried to make my code use "table cells" as opposed to "sheet cells" which makes the code independent of any sheet position changes.
I've attempted to adapt your formula to reflect this policy but as soon as I try to use a table column reference [column name] the problem I descibed to you comes back.
One of the issues I don't understand is why a Range.Copy...Range.Paste does not cause formula curruption but row.select...listRows.Add...Paste does.
Both forms of data transfer work as predicted but for the formula changes. Do you think this is an Excel bug or am I missing something.