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
Bookmarks