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

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" <(E-Mail Removed)> wrote in message
news:c54983c7-e0c5-4583-a638-(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
> news:c54983c7-e0c5-4583-a638-(E-Mail Removed)...
> > 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
> >
>
>
>