View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BeSmart[_2_] BeSmart[_2_] is offline
external usenet poster
 
Posts: 6
Default Command button macro query

Hi al
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.