Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
application.match | Excel Discussion (Misc queries) | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
Application.Match | Excel Programming | |||
Application.WorksheetFunction.Index syntax | Excel Programming |