[VBA][EXCEL] function match.

Hi all,

I have a question about using a table variable as an array.

I declared a two-dimensional variable, [MyTab(18, 1)] with data filled in the value 1 of the second dimension. (the value 0 being empty).

The values entered therefore range from 1.1 to 18.1.

from 0.0 to 18.0 being empty.

I want to retrieve using the WorksheetFunction.Match function the position of one of the values.

For example I am looking for the value 'Toto' which in position 18.5 I wish to have as an answer 5 (or 6 if the 0 is counted).

​

My idea was to write WorksheetFunction.Match("Toto", MyTab, 0) however I don't know how to pass the information to look in all the first dimension (the 18 values) and in the value 1 of the second dimension.

Thank you for your help.

Al3x