How do I determine the size of a multi-dimensional array?
I have an array called table(row,col), which varies every time the program is run. How do I determine how many columns and rows there are?
Thank you.
Jon
Printable View
How do I determine the size of a multi-dimensional array?
I have an array called table(row,col), which varies every time the program is run. How do I determine how many columns and rows there are?
Thank you.
Jon
Use the ubound() function
Code:' Usage:
Dim rowcount as long
Dim colcount as long
rowcount = ubound(table, 1)
colcount = ubound(table, 2)
Thank you