- Application.WorksheetFunction.Match() 会报错,中断程序
- Application.Match() 会报错,但不会中断程序
- 备注点:
- Application.Match("",arr1,0) 错误
- Application.Match("",arr1,0) 正确,不要加引号,否则会查不到
Sub charleszhang1()
arr1 = Array(1, 3, 5, 7, 9)
Debug.Print Application.Match(3, arr1, 0)
Debug.Print Application.WorksheetFunction.Match(3, arr1, 0)
Debug.Print Application.Match(4, arr1, 0)
Debug.Print Application.WorksheetFunction.Match(4, arr1, 0)
End Sub