View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default Application.Index & Application.Match

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