Who even remembers that Excel has Auto Correct settings?
I added code to the User Form, to change those settings, but you can make the same changes manually.
By referencing cells in the current row any insertion or deletion of lines will cause formulas to be updated.In order to refer to cells elsewhere but to name only cell addresses in the current row. Leaving a blank Row 6 allowed for easy insertion of a row without having to change the SUM formula.Unfortunately, things didn't go well on his computer.The data overflowed the table, instead of it expanding automatically.Instead of expanding to include the rows, the table just ignored them.
Fortunately, the problem is easy to fix, if you know how, and if you have the patience to do lots of clicking.
When you click the "Add this part" button, the new record is added at the end of the existing rows.
Everything worked well on my computer, so I sent the file to my client, for testing.
For example, if I have a =SUM(B2: B5), then insert a row in that range with a macro, it doesn't update the 'B5' to 'B6'. Screen Updating = False With Active Sheet For R = Last Row To Start Row 1 Step -1 If .
Is there something I need to add to the macro to get it to update formulas on the sheet?
In the next example the blank Row 6 will be removed and the SUM formula will use OFFSET to simply insertion of lines.