can we use array or collection in excel udf

Hi,

Is it possible to use an array or a collection in excel UDF

I have made use of both but the udf doesnt give any result. When i run in execution mode then it automatically stops at the line where i make use of array.

With collection it doesnt even start.. It gives a compile error.

Regards,
Vaibhav