ParamArrays Are Always Base 0

ParamArray is an optional argument type that allows you to pass a variant array to your function or subroutine. In Microsoft Excel 95, a function with a ParamArray argument may return different results when called from a worksheet rather than Visual Basic code. In Visual Basic to Visual Basic function calls, ParamArrays are base 0 (the index number of the first element is zero). Calling the same function from a worksheet cell would have the ParamArray always be base 1. Therefore, programmers had to use the LBound method to determine the index number of the first element.

In Microsoft Excel 97, Visual Basic now packages all ParamArrays with a 0 base. This will affect function calls with ParamArray arguments that are expecting the first element to be index one. Therefore spreadsheet functions using ParamArrays will need to be modified to work with base 0 ParamArrays.