Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
374
using AfterCellUpdate
posted

in AfterCellUpdate, I check which column was updated (e.cell.column.index) then and if it was the first column, I edit 2 other cells based on the value of a certain column.

To set the values of the other 2 cells, I'm using

e.cell.row.cells(3).value = myvalue1

e.cell.row.cells(4).value = myvalue2

 I get an error on the second line indicating that "Key not found : Parameter name: key"  not sure why this happens, the first line works fine.  I tried replacing the indexes with string keys and get the same results.  Shouldn't I be able to access all the cells from this event?

Is there anything that might cause this to give me this error?

 

Parents
  • 469350
    Offline posted

    Hi,

        Are these columns unbound columns? Perhaps this code is getting called before the unbound column has been created? Maybe you can check e.Cell.Row.Cells.Count and see how many columns actually exist at the time the error occurs.

Reply Children