how to import a 1-demensional array into a function

[luv2glyd]

I have a function that takes in inputs like this:

Please Login or Register  to view this content.

is there a way to input a one-dimensional array into it? If so, how do I refer to it in the setup above?

Thanks

[mehmetcik]

As a text string?

"1, 12,23,abc, def"

Please Login or Register  to view this content.

[mikerickson]

What does your function do?

As it is currently written, does it take single value arguments and return the correct value?

Are you asking how to modify it so that one could make one (or more) of the arguments an array and it would return an array of values? So that it would work properly as an array formula in a worksheet?

What is the rest of the code for the UDF?

[luv2glyd]

Thanks, guys. I figured it out - looks like it works if I just refer to it as a variant.

Mikerickson: in a separate task, I do need another function to return an array of values. Any suggestions? Here's that post:

http://www.excelforum.com/showthread...42#post4522542