stop union range from return back to starting cell

**sunshine076** · 11-17-2010, 12:26 PM

The code below works fine however I have found that it becomes a problem when I have a sheet that goes beyond a certain number and after the data has been entered into a cell that is not on the screen it will return back to the start cell of the range. Is there a way to hide this while keeping the cells locked and whatever cell active to remain there instead of returning back to start cell

Please Login or Register  to view this content.

I commented out myMultiArearange.Select to stop the selection each time a person would make a change to the sheet. It is a nice feature but in my case I didn't need it active.

**Leith Ross** · 11-17-2010, 12:53 PM

Hello sunshine076,

Please post your workbook. With the workbook, we can then see the full layout, with formulas, formatting, and any macro code the workbook contains. This also reduces guesswork in trying to reproduce the problem.