Array in User Function
 

I'm trying to fill an array in a user-defined function and I get the
following error:
Compile error: Can't assign to array

I've tried to input the text as strings and using the address of the
same data in a worksheet and I get the same error. Is there a trick to
this or are arrays not allowed in functions?

Thanks

Array in User Function
 

Yes you can use arrays in UDFs.

Please post your UDF code so we can see what the problem is.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Amish" wrote in message
...
I'm trying to fill an array in a user-defined function and I get the
following error:
Compile error: Can't assign to array

I've tried to input the text as strings and using the address of the
same data in a worksheet and I get the same error. Is there a trick to
this or are arrays not allowed in functions?

Thanks

Array in User Function
 

Are you trying to pass a range object into the function, use an array inside
the function, or return the array?

"Charles Williams" wrote:

Yes you can use arrays in UDFs.

Please post your UDF code so we can see what the problem is.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Amish" wrote in message
...
I'm trying to fill an array in a user-defined function and I get the
following error:
Compile error: Can't assign to array

I've tried to input the text as strings and using the address of the
same data in a worksheet and I get the same error. Is there a trick to
this or are arrays not allowed in functions?

Thanks