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.
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)
Bookmarks