View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Auto Navigate Cells

Hi,

There are two possibilities :

1. Select all your input cells in one go in order to Insert Name Define
....
Once you have created a range, you will be able to Tab from one cell to
the other ...

2. Slightly more sophisticated, the same approach but encapsulated into
an event macro
private worksheetchange ...

HTH
Carim