'VSTO(.vb) uses EXCEL built-in function Match() exception
Project is VSTO Excel Add-in (vb), when using EXCEL built-in function Match(), an exception occurs.
Imports excel = Microsoft.Office.Interop.Excel
Function match_out ()
Dim index As Integer
'The build error is here
index= excel.WorksheetFunction.Match(1, {2, 1})
return index
End Function
I want output result:
index = 2
but feedback:
error:BC30469 Reference to a non-shared member requires an object reference
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
