Tab key

[Rolou]

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

[Gord Dibben]

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" <Rolou@discussions.microsoft.com>
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