Counting dimensions of a dynamic array

[Kelvin Stott]

I am working with dynamic arrays that may be assigned from a variety of sources (variable ranges, data strings, or other arrays) and need a simple way/function to count how many dimensions an array has at any moment, so that I can use other functions to manipulate the array in the correct manner, depending on the number of dimensions.

Is there a simple function/formula to count the current number of dimensions in a dynamic array, without having to keep track of this with an independent variable?

Again, any help would be much appreciated, thanks!

Best regards,
Kelvin

 

[hiker95]

Kelvin Stott,

See if this helps.

Determining the Number of Dimensions in an Array Variable

 

[Kelvin Stott]

Great, thank you.

 

[hiker95]

Kelvin Stott,

You are very welcome. Glad I could help.

Come back anytime.

 

[Kelvin Stott]

It's funny, as a purist I spend so much time trying to write perfectly efficient and reliable code without any errors, and now I find that the only way to do this simple task is to create an intentional error!