1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible to apply a name to a variable range?

I am using this sequence to fill the number of years needed. I can select the currently used cells and apply a name to the range normally, but that will not update if the number that "working_years" is referencing changes. Is it possible to apply a name to the cells in the sequence that will update what the name is referring to whenever the number of cells in the sequence changes?

I am using the 2021 desktop version of Excel.

https://preview.redd.it/2wzz7kln0ftg1.png?width=470&format=png&auto=webp&s=a23f609710ca59c311a865682bf0c57c3d9fadd8

submitted by /u/plushieblahaj
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com