I would like to use the tab key to move from a specific cell to another non
adjacent cell without having to press tab at the cells in between. Ex: A1,
press tab and A5 woul become the active cell.

Thanks
Roland

Rolou

See Bob Phillips' site for hints.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is also a method using VBA and a case select code.

If you want to use that, post back.


Gord Dibben Excel MVP

On Mon, 7 Nov 2005 15:48:05 -0800, "Rolou"
wrote:

I would like to use the tab key to move from a specific cell to another non
adjacent cell without having to press tab at the cells in between. Ex: A1,
press tab and A5 woul become the active cell.

Thanks
Roland