Runtime error in Microsoft Office Interop Excel

Question

I am trying to speed up processing of an Excel worksheet through the use of the Excel.find feature. I am using Excel 2013, running windows 10 and Visual Studio Express 2013. My Visual basic code snippet is as follows:

Imports Excel = Microsoft.Office.Interop.Excel
Imports word = Microsoft.Office.Interop.Word
Imports Microsoft.Office
Imports System.Runtime.InteropServices

oXLSheet = oXLBook.Worksheets(year_value.ToString)
oXLSheet.Select()
Dim search_str As String
search_str = oXLSheet.find("balance propagation", LookIn:=xlValues)

The last statement produces the following runtime error"

"Public member 'find' on type 'Worksheet' not found"

What is causing this/

Answer 1

Try something like this:

. . .  
Dim r As Range  
r = oXLSheet.UsedRange.Find("balance propagation", LookIn:=xlValues)  
. . .