Array in User Function

  • Thread starter Thread starter Amish
  • Start date Start date
A

Amish

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?
 
Back
Top