See Bob Phillips' site for a couple of methods.
http://www.xldynamic.com/source/xld.xlFAQ0008.html
You could also use sheet event code to leap from one cell to another as you
ENTER out of each cell.
Post back if that interests you.
Gord Dibben MS Excel MVP
On Tue, 14 Aug 2007 08:28:00 -0700, APK wrote:
How do I move or jump from one cell to another avoiding other cells in
between. Example If I was in cell A1 and want to go to cell D6 next the go to
G8 the return turn to A2, how could I do this.