Can the attachment be completely turned into VBA? (No More Formula)

[wk9128]

First explain that the formula can complete the task, why not change the VBA reason as follows
The reason is that the formula cannot be used when inserting a row

J16:J34 contains formula,
The formula can be used when J16:J34 delete ROW
When J16:J34 is inserted into ROW, the formula cannot be used because the inserted row cannot be calculated
When inserting a row, there are formulas at the top and bottom, and the formula for inserting the row is gone

I want to turn J16:J34 into VBA without using formula and can insert and delete in J16:J34
The formula for adding J35 is applicable to J16:J34. Inserting and deleting columns does not affect the calculation. I also want to change J35 to VBA.

---

Cross post
https://www.excelforum.com/excel-pro...e-formula.html



https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA