HRESULT: 0x800A03EC on Worksheet.range

The Solution to HRESULT: 0x800A03EC on Worksheet.range is


This problem occurs if you are using a backwards compatible sheet (a .xls) instead of a .xlsx

To allow sheets to be opened in pre office 2007 version it can't contain more than 65k rows. You can check the number of rows in your sheet by using ctrl+arrowdown till you hit the bottom. If you try to get a range larger than that number of rows it will create an error

~ Answered on 2011-08-18 13:45:31


Most Viewed Questions: