Two dimention dynamic Array (row ,column)

[vbakan]

Hi All,

I have problem in finding the dimention of the two dimention array

eg

MyArray looks like this
0 1 2 3 4 5 6 7 8 9
a s d f g h j k z x

I want to get the x location in my example (2,9) When I use UBound(MyArray) I get 1, it is giving the row max.

Can any one help me how to get the col max in this sinario please ?

Thanks,

 

[SkipVought]

Hi,

There's [tt]UBound(MyArray, 1)[/tt] and [tt]UBound(MyArray, 2)[/tt] depending on which dimenstion you want.

Skip,

_[red][/red]

 

[vbakan]

Thank a lot it is a grate help

 

[kjv1611]

Pretty rough, hu? Kind of grating you the wrong way?

Just kidding of course, just found that humorous!

--

"If to err is human, then I must be some kind of human!" -Me