Thanks, that code works exactly right as I needed.

Although I have noticed a buggy thing about it.

Only when i leave a cell by pressing enter or the down arrow does it update the correct row. If i simply delete or paste, it updates the row above, and the other directional arrows also result in an incorrect row update.

Is there anyway around this, or should i just remember these concerns?

Thank you