Any idead how to solve 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

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.