Referring to Cells in Excel by Using Index Numbers

smatijevsmatijev Member Posts: 12
Has anybody managed to refer to cells in Excel in any way other than by Range (A1 notation)? To be precise, I'm interested in referring to cells using index number. I tried to use
WorkSheet.Cells(2, 3).Value := SomeValue
to put SomeValue into cell B3 as it is stated in VB help but id doesn't work in Navision because Cells doesn't take any arguments.

Comments

  • fbfb Member Posts: 246
    Try
    Worksheet.Cells.Item(RowIndex, ColumnIndex).Value := SomeValue
    
Sign In or Register to comment.