I have a function that takes in inputs like this:
is there a way to input a one-dimensional array into it? If so, how do I refer to it in the setup above?Please Login or Register to view this content.
Thanks
I have a function that takes in inputs like this:
is there a way to input a one-dimensional array into it? If so, how do I refer to it in the setup above?Please Login or Register to view this content.
Thanks
Last edited by luv2glyd; 11-14-2016 at 05:32 PM.
You either quit or become really good at it. There are no other choices.
As a text string?
"1, 12,23,abc, def"
Please Login or Register to view this content.
Last edited by mehmetcik; 11-12-2016 at 06:00 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
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?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
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
Last edited by luv2glyd; 11-14-2016 at 05:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks