onChange to Copy Down Formulas

Not sure why you have an error, but I’m finding there is still an issue. It seems you cannot use an Arrayformulas to iterate each row as a separate parameter into a function.
You would probably have to change the function to pass in a range and then return a range of rows. I’ll keep playing, but I’m not sure yet if it will work. Arrayformulas are so unintuitive to me sometimes. Something that makes perfect sense in my head won’t always translate well to array formulas.

One alternative would be to create a second sheet and prepopulate the formulas several times. Then use a formula to pull in the data from the first sheet. =Sheet1!A1:F