Hello,
I'm using a ROWS function to list the rows of a table with integers 1 through the rest of the table (Using the method for the "Helper 1" column found at this link: https://trumpexcel.com/extract-data-...rop-down-list/). It generally works fine, but the problem arises when I try adjusting the range of the table to add more rows, be it manually, by the Insert command, or by VBA script.
Basically, the formula in whichever cell was in the last row changes to match whatever the new last row becomes. I can't seem to figure out how to get Excel to not do this. Here's a few screenshots to illustrate the issue: https://imgur.com/a/GlyUt
I should note that I'm using Excel 2010. Thanks for any assistance.
I'm using a ROWS function to list the rows of a table with integers 1 through the rest of the table (Using the method for the "Helper 1" column found at this link: https://trumpexcel.com/extract-data-...rop-down-list/). It generally works fine, but the problem arises when I try adjusting the range of the table to add more rows, be it manually, by the Insert command, or by VBA script.
Basically, the formula in whichever cell was in the last row changes to match whatever the new last row becomes. I can't seem to figure out how to get Excel to not do this. Here's a few screenshots to illustrate the issue: https://imgur.com/a/GlyUt
I should note that I'm using Excel 2010. Thanks for any assistance.
