Formulas auto-change when inserting rows

Oct 31, 2013 at 6:05 AM
Edited Oct 31, 2013 at 7:00 AM
Hi. I have such situation. I need to insert some number of rows, which at the end of "these" there is formula and it must calculate it some column value. Formula is like "SUM(J17:J17)" and is located in J18 or anywhere else. If I use InsertRowsBelow method and add 1 row below the row which contains "J17" , the formula must be changed to "SUM(J17:J18)" . If there is such function parameter to set, which will make its done?
Nov 8, 2013 at 12:44 PM
Could you do SUM(J17:J$17) ?
Alternatively, hide row 16 and make the formula =SUM(J16:J17)
Then when you insert at row 17 it will become = SUM(J16:J18)
Just have to make sure you have no data in row 16!