Adjusting table range modifies ROWS formula

Jimithy

New Member
Joined
Apr 5, 2018
Messages
8
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.
 

Forum statistics

Threads
1,082,438
Messages
5,365,531
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top