View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default Moving from range to range

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.

"laurick" wrote:

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
--
Rick