View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JerryH JerryH is offline
external usenet poster
 
Posts: 12
Default Know which cell was just left

I have a sub I want to run each time a cell is changed. However, I need to
know which cell was active when the enter key is pressed. When I look at
active cell on Worksheet_Change it gives me the current cell with focus but
not the one the data was changed on.

thanks,
Jerry