^There are two ways that I use Named Ranges in excel. The most important way is for making formulas clear. May not matter for small formulas, but for a large forumula with things crossing multiple sheets it makes it much clearer to just make a constant or some range a Name. The second way is that if I have some range that I have to update every month in multiple places, it’s easier to make it a named range and then change it only in that one place and then have that update everywhere else in the file. Alternately it could be that I have a formula in multiple places and if the range changes (like if I get more data) then I need to change the formula in a bunch of different places. Kind of a hassle.
That’s a faid defense of named ranges, jmh. I hadn’t thought about how they could make regular updaets of a model easier. I’ll have to keep that in mind the next time I build something.
Me either. That’s a great point, thanks for sharing. I usually use CTRL F and find/replace that range, but its not as clean and prone to accidental error.