And how do I enter the argument when I use the function.
Can I just do:

zzz(colors())

-----Original Message-----
Use the ParamArray keyword
Function zzz(ParamArray myarr())

" wrote:

I am trying to find out how to pass an array as an
argument for a custom function.
I have an array colors(1 to 10) and I want to pass the
whole array into a custom fundtion so I can use the
array
within the function.

Thanks.

.