It is not elegant, but the user can click on Edit, Undo, and then Edit, Redo
and that will put them back to the last modified cell and the cell will be
as modified.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"BeSmart" wrote in message
...
Hi all
Is there a function (eg Shift Cntrl R) or maybe I need to create a command
button that when clicked, will return the user to the last cell they
entered?

Currently the user enters data on a row, then scrolls down heaps of rows
(in which other data is entered) to the totals row (or they use the name box
to select a defined cell that refers to the totals they want) and they check
the results. They then want to return to the cell they just entered but are
finding it cumbersome to find it.

Any help would be greatly appreciated.