Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rule to recall collection lower bound index ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rule to recall collection lower bound index ?
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. -- Jim "Michel S." wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
recall cell value in hyperlink | Excel Worksheet Functions | |||
How can i Recall a Value? | Excel Worksheet Functions | |||
Arrays - Lower Bound and Singleline Assignment | Excel Programming | |||
recall records | Excel Programming | |||
Need Help with Set Object = Collection(index) | Excel Programming |