I'm working on another new spreadsheeet. I'm sure I'll have still more
questions. But as I think through how it will work, I thought of a
generic question about spreadsheet design. I'm sure some of you have
ideas on this.

When deciding on overall approach, testing a list of some kind, how do
you decide whether to define the list as a range and then do a "For
each rCell in rRange" loop or just start from the top and work your way
down through the list using a test for a blank cell to determine when
to stop?

Obviously, if there are blank cells in the column you're testing, you
would probably use the first (defined range) approach. But what if
there aren't blanks in the data?

Any suggestions and reasons for making that choice?
Thanks!