Cell tab order

[~Craig]

Is there a way to control the order you tab to specific
cells? For example, I would like to hit tab to jump to
cells in this order:

A1, B14, J5, H24, and A15

 

[Paul B]

Craig, here is one way,
Select the Second cell you want in the range then CRTL + click your way
through the range, ending with the First cell in the range. Name this range
under insert, Name, Define>OK.

Now click on NameBox, select the named range and you can Tab or Enter your
way through the range in the order you selected starting at First cell.

There is a limit of about 25-40 cells you can put into a Named Range due to
a
255 character limit in the Named range.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[~ Craig]

Brilliant - thank you Paul!

-----Original Message-----
Craig, here is one way,
Select the Second cell you want in the range then CRTL + click your way
through the range, ending with the First cell in the range. Name this range
under insert, Name, Define>OK.

Now click on NameBox, select the named range and you can Tab or Enter your
way through the range in the order you selected starting at First cell.

There is a limit of about 25-40 cells you can put into a Named Range due to
a
255 character limit in the Named range.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **





.

 

[~Craig]

I have been able to establish this with a small
spreadsheet.

With a larger spreadsheet I have 25 tabs I need to go in
order and after CTRL + clicking, when I name the range, I
receive this error message:
"Your formula cotains an invalid external reference to a
worksheet. Verify that the path, workbook, and range or
cell reference are correct, and try again.

I am not referencing a external worksheet.