VBA & Macro Problems

Move to the Next Excel Input Column After Data Entry

Amos GikundaAmos Gikunda Nov 22, 2026 868 views

Question details

Set up Excel to move from the end of one input range to a specific starting cell in the next column.

Move to the Next Excel Input Column After Data Entry
Product
Microsoft Excel
Device & OS
not provided
Scenario
Users enter data in designated cells, such as A18:A60, and then need to continue at C18 without using the mouse.
Observed behavior
Worksheet protection can restrict selection to unlocked cells, but Excel may move to another unlocked cell instead of the desired starting row.
Before you start

Identify the input ranges and any other cells users must edit. The VBA method requires a desktop version of Excel that supports macros and a macro-enabled workbook.

Solution 1Recommended

Use a Worksheet Change Event to Select the Next Input Cell

Use this method when the next input column must begin at an exact cell, even if other cells are unlocked.

1
Unlock input cells

Select the cells users need to edit, including A18:A60 and C18:C60. Open Format Cells > Protection, clear Locked, and click OK. Repeat for any other editable cells.

2
Protect the worksheet

Go to Review > Protect Sheet. Allow Select unlocked cells and clear Select locked cells, then apply protection. A password is optional.

3
Open the worksheet code

Right-click the worksheet tab, choose View Code, and paste the following into that worksheet's code window: Private Sub Worksheet_Change(ByVal Target As Range) If Target.CountLarge <> 1 Then Exit Sub If Intersect(Target, Me.Range("A60")) Is Nothing Then Exit Sub If IsEmpty(Target.Value) Then Exit Sub Me.Range("C18").Select End Sub

4
Save and test

Use File > Save As and select Excel Macro-Enabled Workbook (*.xlsm). Reopen the file, enable macros if prompted, and enter a value in A60. Confirm that C18 is selected; adjust the cell references in the code for your own ranges.

Use a Worksheet Change Event to Select the Next Input Cell
How the event works: The event runs for a single-cell change to A60, not for a formula recalculation or a multi-cell paste. It selects C18 without unprotecting the sheet, so there is no need to put the protection password in the code. Test the behavior with your Excel settings and entry workflow.
Free Microsoft Office alternative

Manage Spreadsheet Input Ranges with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and move everyday spreadsheet work to WPS; test any Excel VBA automation separately because macro behavior may differ.

Edit spreadsheet input ranges in a familiar interfaceCompatible with Microsoft Excel formats such as XLSXFree and lightweight for everyday office workOpen existing spreadsheets to support a smoother transition
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel move to B6 instead of B18?

B6 may be an unlocked cell that Excel includes in its protected-sheet navigation order. Lock cells that do not need editing, or use a Worksheet_Change event to select the exact destination.

Can I send users the workbook without giving them the protection password?

Yes. Protect the sheet through Review > Protect Sheet and leave the input cells unlocked. The example VBA event selects an unlocked destination without removing protection or storing the password.

Where do I put the Worksheet_Change code?

Right-click the relevant worksheet tab, choose View Code, and paste the event into that worksheet's code window. Save the file as an Excel Macro-Enabled Workbook (*.xlsm).

Why doesn't the macro run when a formula changes A60?

Worksheet_Change responds to changes made to cells, not formula recalculations. The example is intended for a value entered directly into A60.