I have this sheet change event handler which places shapes on the sheet. On exit from the handler the last shape placed is selected. I have added a "target.select" at the end of the handler which works fine if I just enter a value in a cell.
If, however I move the cursor (up, down, left or right, or even pageup or pagedown) instead of pressing enter after changing the value I do not ended up in the expected destination cell. Instead it brings it back to target.
How can I end up where my cursor key is supposed to take me to.