Greetings,

I found that I can move between specific cells by using the name range
feature, but this has a limit of 255 characters, which means I can
only select about 25-30 cells.

The spreadsheet I am working on, I need to tab between 115 different
cells.

I set up a VB script to use:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address

However, the code above requires me to change each cell before moving
to the next cell.


My delema is that sometimes I will need to change specific cells, and
other times I wont need to change them. Is there a different syntax
that I should be using to get the tab order set up correctly for both
cells that change and cells that remain unchanged?

Thanks!
Brian