Hi everybody,
I have a very simple problem.
I have a variant that is a two dimensional array.
UBound(arrayName) gives the no of rows. How do I get the no of columns?
Thanks,
Flair
Printable View
Hi everybody,
I have a very simple problem.
I have a variant that is a two dimensional array.
UBound(arrayName) gives the no of rows. How do I get the no of columns?
Thanks,
Flair
I don't understand. If it's a two-dimensional array then it will always have two columns :confused:
Ubound(MyArray, 2)
the second dimension
That's it. I knew it but couldn't think of it. I've written it in my book. I'm surprised that M$ didn't list it.
Thanks Rob.
Cheers!