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.
I want to get the offset but it shows the below error.
Run-time exception thrown :
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: