I've been trying to get SERIESSUM to work for a long list of automatically
generated coefficients.

=SERIESSUM(1.005,1,1,{1,1,1,1,1,1}) works very well. I can create the array
of ones using VBA too by creating a function that has the number of ones
desired as the input and the array as type variant output.

My question: Is there a worksheet function that can generate an array of
ones. Normally an array of 6 ones is not a problem but I need to generate an
array consisting of anywhere from 200 - 360 ones that can be done on the fly
without storing the ones in a column.

I've scratched my head for a while but seem to find that the VBA method is
the only way this can be done. Any suggestions for a non-VBA or non-column
method?

Thanks,
RK