Moving from range to range

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
 
R

Ron@Buy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top