Forum Discussion
EXTENDING A NAMED RANGE
I have a range of cells in a sheet that is named, and formulas in a different sheet refer to that range. I inserted a row into the middle of that range (had an entry to add), and now one row at t...
Hi
If you will be continuously adding or removing rows of transactions, the, instead of reediting the named range with each change, convert the range as a Table (CTRL +T) >> Name the Table >>and whenever you add or delete rows the table auto-expands to accommodate the change.
Hope that Helps
Nabil Mourad
