Thread: Return Array Dimenions

can anyone tell me how to return the number of dimenions that are in an
array? I know I can return the number of elements using Ubound (dimenion #,
array). But I want to return the dimension number.

Thanks

EM

Here's one http://www.devx.com/vb2themax/Tip/18265

NickHK

"ExcelMonkey" <ExcelMonkey@discussions.microsoft.com> wrote in message
news:9A2C7DF0-B73F-442D-9160-7DDDCD8EF021@microsoft.com...
> can anyone tell me how to return the number of dimenions that are in an
> array? I know I can return the number of elements using Ubound (dimenion
#,
> array). But I want to return the dimension number.
>
> Thanks
>
> EM

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ArrayDimensions(MyArray)

Alan Beban

ExcelMonkey wrote:
> can anyone tell me how to return the number of dimenions that are in an
> array? I know I can return the number of elements using Ubound (dimenion #,
> array). But I want to return the dimension number.
>
> Thanks
>
> EM