Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I keep getting a strange error when I try loop through excel's cells and find one with cotaining no data. I get an unhandled exception of type 'System.Runtime.InteropServices.COMexception'.... Exception from HRESULT: 0x800A03EC. My code is as follows
D I += If mExcel.Range("A5").Text = " " The ....do somethin Loop While MyExcel.Range(strBoth).Value < " The if statement is the line causing the error. I've tried multiple vartions of the loop. I've refrenced the COM microsoft excel 10.0 and am running Office XP pro. I also included Imports Microsoft.Office.Core. Thanks for any help. Any useful links/examples would also be greatly appreciated. PS I've mananged to make it through the if statmet a few times but I 've also been getting various cast exception errors regarding mscorlib.dll. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unhandled exception - Not implemented | Excel Worksheet Functions | |||
WHAT ARE THE CAUSES FOR 'EXCEPTION ERROR ' | Excel Discussion (Misc queries) | |||
Excel.Range.Name gives error an exception | Excel Discussion (Misc queries) | |||
Remind me to set Error Trapping to Break on Unhandled Errors | Excel Programming | |||
Exception Error? What is it? | Excel Programming |