Computer Learning Zone
Microsoft Access VBA Error 9: Fixing Subscript Out of Range
11:22
Run-time error 9, "Subscript out of range," usually means VBA is trying to access something that does not exist. Often it is an array position outside its valid range, but it can also involve missing collection items or keys.
This episode explains what a subscript is, why indexes can be too high or too low, and why zero-based arrays created with VBA's Array function are a common source of…