Tab key

[Guest]

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