You could use a named range.

See Bob Phillips' site for creating a named non-contiguous range you can Tab or
Enter through.

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


Gord Dibben MS Excel MVP



On Mon, 23 Jul 2007 11:24:01 -0700, thaenn
wrote:

Is there a way to "tab" down a specific number of rows in a worksheet, that
can be set up? I have blocks set up in a worksheet and after filling
information in the first block, I would like to go directly down to the start
of the next block. Tab/Enter is not enough, page down is too many?
Thanks for the help...