Unknown number of arrays as argument to VBA function

When you call the function, will the vectors always be consecutive (B,C,D,E...) or can they be required to be consecutive? If so, then you could reduce all of your one dimensional array arguments into a single 2 dimensional array:

function smatrix_C(arr1 as variant) as variant
...
end function

called as =smatrix_c(b2:f523)

Unfortunately no. The argument needs to be able to take none consecutive columns of data :S