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
|