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?
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.