Array in User Function

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
 
J

Joel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
how pass array to a function? 14
Declare a Public Array 5
Use VB array as as argument for worksheet function 9
Setting an array of text boxes equal to individual form text boxes 6
array output to cell range 5
Excel Worksheet Function Large 2
Array assignment 1

Top