I have a
question for you though, you used ranges specified by names ("year", "data",
etc)...is that how you would define a range  if the range was named?

In a named  range, is it the equivalent of doing a "for each"? Meaning, would
it check each of the cells in that range at once?

I've never really worked with named ranges before, but I have to say it
looks a lot cleaner, and quicker than what I've been doing, so I'm
intrigued...