So much for trying to learn  this stuff from books. That's the first
time I've gotten a clear idea  of what a Collection is, that Excel VBA
is object-oriented programming, and that EOL and BOF aren't even
useable in Excel VBA. Please bear with me as I ask more ignorant
questions.

1. What are the other items in the Excel Collection(s)? Where can I
find a list of such things, so I know what I can refer to and what its
proper name is? How was I to know that worksheet objects are called
"Sheets" and not  "Worksheets" or "Tabs"?

2. I understand  about Option Explicit, and why it's essential, but I
note that the routine you sent me leaves the variable to be defined by
default as Variant. Could Option Explicit have caused a problem
because the variable(s) were not explicit?

3. I notice that when I record a macro, and in the code  you sent me,
the whole thing  is called a "sub". I imagine that's what makes it
callable by name from other macros. What's a "procedure" and how do
procedures relate to macros  and subs?


4. How is "method" defined, and where can I find a list of the
methods available in Excel VBA? Is a method a kind of verb that acts
on an object, which is analogous to a noun? How can I find the
syntactical requirements for methods, and for that matter, what they do)?