ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moving from range to range (https://www.excelbanter.com/excel-worksheet-functions/175298-moving-range-range.html)

laurick

Moving from range to range
 
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

Ron@Buy

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



All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com