ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Return Array Dimenions (https://www.excelbanter.com/excel-programming/366536-return-array-dimenions.html)

ExcelMonkey

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

NickHK

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

NickHK

"ExcelMonkey" wrote in message
...
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




Alan Beban

Return Array Dimenions
 
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



All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com