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?