0

My question is quite simple, but haven't been able to figure out how to solve.

I have and function that I cannot see the code and the function always returns an array. It's not that I can't tell the size of the dimensions, there you can use Lbound and Ubound, but how can I tell how many dimensions the returned array has?

There is no code I can give, and I believe the problem doesn't require such to be selfexplaining. But is there a method, function or such with array that tells the dimensions of the array?

Community
  • 1
  • 1
Han Soalone
  • 862
  • 8
  • 18
  • See: http://answers.microsoft.com/en-us/office/forum/office_2003-excel/how-many-vba-array-dimensions/a4c80919-3cd3-4ed0-a173-b9b8fabd3c83 – Gary's Student Aug 27 '14 at 12:51
  • 2
    Use a counter to loop through array dimensions returning the Lbound of each dimension until you trigger an error: `x = lbound(arr, i)` `i = i + 1` – Orphid Aug 27 '14 at 14:18

0 Answers0