Thanks Hector!
After reading your reply I now realise I don't have to worry about
which key the user presses to enter the value. What I was after was a
way of figuring out the address of the last changed cell. All the time
it was staring me in the face, it's the target cell that changed!
Your reply has given me some other ideas too. I don't want the user to
type any text, just a number.
Thanks for going to the trouble of responding to and solving my silly
problem.
Ken Johnson