LinkBack URL
About LinkBacks
How can I define a Function in VBA excel that returns two array?
How can I define a Function in VBA excel that returns two array?
Easier to answer if you provide a sample workbook.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
And what does your input data look like ?Originally Posted by niksirat2030
When creating a function, we generally think of returning a single value (array, object, etc.). But, by using parameters passed ByRef (the default way to pass arguments), you can return multiple values. And the result of a function, for example, can tell you whether the calculation was successful.
Two examples of this approach:The function can also return an array of arrays:
Please Login or Register to view this content.ArtikPlease Login or Register to view this content.
Last edited by Artik; 09-04-2022 at 07:44 AM.
Please Login or Register to view this content.
Last edited by mjr veverka; 09-04-2022 at 09:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks