Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name

by

The error code 0x800A03EC (or -2146827284) means NAME_NOT_FOUND; in other words, you’ve asked for something, and Excel can’t find it.

This is a generic code, which can apply to lots of things it can’t find e.g. using properties which aren’t valid at that time like PivotItem.SourceNameStandard throws this when a PivotItem doesn’t have a filter applied. Worksheets["BLAHBLAH"] throws this, when the sheet doesn’t exist etc. In general, you are asking for something with a specific name and it doesn’t exist. As for why, that will taking some digging on your part.

Check your sheet definitely does have the Range you are asking for, or that the .CellName is definitely giving back the name of the range you are asking for.

More Related Contents:

  1. Excel Interop – Efficiency and performance
  2. Exception from HRESULT: 0x800A03EC Error
  3. Fastest way to interface between live (unsaved) Excel data and C# objects
  4. How to open an Excel file in C#?
  5. How to reference Microsoft.Office.Interop.Excel dll?
  6. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  7. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  8. How to know if a cell has an error in the formula in C#
  9. Excel CustomTaskPane with WebBrowser control – keyboard/focus issues
  10. How do I get an Excel range using row and column numbers in VSTO / C#?
  11. Write Array to Excel Range
  12. Format an Excel column (or cell) as Text in C#?
  13. How to write some data to excel file(.xlsx)
  14. Silent failures in C#, seemingly unhandled exceptions that does not crash the program
  15. Why aren’t variables declared in “try” in scope in “catch” or “finally”?
  16. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  17. What are checked exceptions in Java/C#?
  18. Read Big TXT File, Out of Memory Exception
  19. How to get Exception Error Code in C#
  20. How to serialize an Exception object in C#?
  21. Autonumber with Entity Framework
  22. More Elegant Exception Handling Than Multiple Catch Blocks? [duplicate]
  23. ArgumentOutOfRangeException on initialized List
  24. How can I handle forms authentication timeout exceptions in ASP.NET?
  25. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  26. How to handle Task.Run Exception
  27. “Asynchronous operations are not allowed in this context”
  28. The given key was not present in the dictionary. Which key?
  29. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  30. How to make [DebuggerNonUserCode] hide an exception from the debugger in simple test case?

Leave a Comment