Return multiple variables from a Function

[heimdaloz]

I am relatively new to programming. I am trying to return multiple variables from function.

I have read a couple of posts that outline that this is not possible. They suggest that this can be solved by passing a array. I understand how to do this, however what if one of the variables is an array. I assume you cannot store an array within an array.

Thanks

 

[sheetspread]

I assume you cannot store an array within an array.

Check these out:

https://www.mrexcel.com/forum/excel...-vba-create-jagged-two-dimensional-array.html

https://www.mrexcel.com/forum/excel-questions/565737-loop-through-jagged-arrays.html

https://www.mrexcel.com/forum/excel-questions/638039-redim-array-arrays-jagged-array.html

 

[Jaafar Tribak]

You have 2 other options:

1-Store data in a UDT .

2-Pass the function argument(s) ByRef.

 

[heimdaloz]

Thanks Jaafar, I have not come across a UDT in my limited time playing with VBA. It is an eye opener and presents me a way to simplify my code considerably. I really appreciate the pointer