Hi Richard,

That helped fully.

Many thanks,

Antonio

"RichardSchollar" wrote:

Antonio

I should have said that the help file you want is entitled:

Using Microsoft Excel Worksheet Functions in Visual Basic

Look for this one.

Hope this helps!

Richard



On 5 Feb, 11:28, Antonio wrote:
I have seen the following code in a previous question:

Dim N As Variant
Dim arr As Variant
Dim arr2 As Variant
Dim strMessage As String

'Fill the array.
arr = Range("A1:B50").Value

'Return the second column of the array
arr2 = Application.Index(arr, 0, 2)

'Find the position in the array of "77"
N = Application.Match(77, arr2, 0)

I have tried to find help on Application.Index and Application.Match but
have not been successful.

Can someone point me to a help page explaining the syntax of these two
functions.

Thanks,

Antonio