![]() |
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 |
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