You could name the cells and call the named range from the Name Box drop
down.

Select the SECOND cell and hold down CTRL and select the remaining cells
ending with the FIRST cell you want. While still selected, click in the
name box and name the range. Now from the name box drop down you can select
the named range and Tab or Enter will advance you to the next cell in the
order you selected prior to naming.

If you have more than about 20 to 25 cells, you may have to use more than
one named range. Seems to bog down around that many cell or there about.

HTH
Regards,
Howard


"shad" wrote in message
...
I need to tab from one validated cell to another