ExcelBanter - Exception from HRESULT: 0x800A03EC

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Exception from HRESULT: 0x800A03EC (https://www.excelbanter.com/excel-programming/394703-exception-hresult-0x800a03ec.html)

Samir1014

Exception from HRESULT: 0x800A03EC

Any idead how to solve Exception from HRESULT: 0x800A03EC

Samir1014

Exception from HRESULT: 0x800A03EC

Hi Experts,

Found the cause when the Error is occured but no solution, could any body
help me here

The cause of Error : When writing to cell no 257

Code lines

DirectCast(Me.moxlWorkSheet.Cells(iRow, iCol), Excel9.Interop.Range)

where
iRow=1
iCol=257

workings fine from 1 to 256

Is any other method to refer and write to a particular cells.

Thanks in adv.

"Samir1014" wrote:

Any idead how to solve Exception from HRESULT: 0x800A03EC

Norm

Exception from HRESULT: 0x800A03EC

The worksheet size in Excel is limited to 65,536 rows by 256 columns

"Samir1014" wrote:

Hi Experts,

Found the cause when the Error is occured but no solution, could any body
help me here

The cause of Error : When writing to cell no 257

Code lines

DirectCast(Me.moxlWorkSheet.Cells(iRow, iCol), Excel9.Interop.Range)

where
iRow=1
iCol=257

workings fine from 1 to 256

Is any other method to refer and write to a particular cells.

Thanks in adv.

All times are GMT +1. The time now is 03:38 AM.