Rule to recall collection lower bound index ?

[Michel S.]

Hello !

In VBA, the Worksheets collection starts at Item 1.

The Controls collection starts at Item 0 (as do most collections).

Is there a "rule of thumb" for one to recall which collections start at
1 and which start at 0 ?

Does this rule stands between versions ? VBA 5 / VBA 6 / VB .Net ?

Thanks

 

[Jim Rech]

VBA (including userforms) was grafted on to Excel and is, in many ways, a
different application. I think we can say that Excel collections
(workbooks, worksheets, names, ranges, shapes...) start at 1 most of the
time, if not always.