Moving from range to range

  • Thread starter Thread starter laurick
  • Start date Start date
L

laurick

I am trying to set a specific set of cells in a form and when done with the
first set of cells to go to the next set of cells which are futher down the
sheet by clicking return
 
Assuming you do not want to make entries in the intermediate cells the
simplest solution is to "lock" the cells and when protecting the sheet tick
the select unlocked cells and untick the locked cells. This will then make
the cursor jump the locked cells and stop in the first unlocked cell. A
little experimentation should give the desired result.
 
Back
Top