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...