Question Excel Offset Member not found

friendship.ani

New member
Joined
Aug 14, 2008
Messages
3
Programming Experience
1-3
hi,
I am new to .net.Plz bear with me.I am using excel with vb.net.
I have a cell named "from" in my xls file.

VB.NET:
Dim rng As Excel.Range

rng = excelWrkSht.Cells.Find("from", excelapp.ActiveCell, Microsoft.Office.Interop.Excel.XlFindLookIn.xlFormulas, Microsoft.Office.Interop.Excel.XlLookAt.xlWhole, _
Microsoft.Office.Interop.Excel.XlSearchOrder.xlByRows, Microsoft.Office.Interop.Excel.XlSearchDirection.xlNext)

rng.offset(0,1).value

I want to get the offset but it shows the below error.
Run-time exception thrown :
System.Runtime.InteropServices.COMException - Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
 
Last edited by a moderator:
Back
Top