How to Move Down One Cell Using Excel VBA (with 4 Useful Applications)

If you want to move down one cell from a specific cell or an active cell in a very large dataset then it will not be feasible always. You can smartly handle it using VBA. So I will show 4 useful examples of VBA for moving down one cell from another one.

How to Move Down One Cell Using Excel VBA: 4 Macro Codes

To show the examples, we’ll use the following dataset that represents some salesperson’s sales in different regions.

Example 1. Use VBA to Move Down One Cell from the Active Cell

In our very first example, I’ll show how to move down one cell from the active cell using a simple VBA Macro. The macro will move down from Cell C6 to C7.

Steps:

• Press Alt + F11 to open the VBA window.
• Then click as follows to insert a new module: Insert ➤ Module.

• Next, type the following codes in it-

Sub MoveDown_ActiveCell()
ActiveCell.Offset(1).Select
End Sub

• After that go back to your sheet.

• Now make a cell active, I activated Cell C6.
• Later, click as follows to open the Macro dialog box: Developer ➤ Macros.

• Select the specified Macro name and press Run.

Now see that the Macro has moved down to Cell C7 from the active cell C6.

Read more: How to Shift Cells Down in Excel

Example 2. Use of VBA rowOffset to Move Down One Cell from the Active Cell  

Now we’ll do the same task in a bit different way. We’ll use rowOffset within the Offset function in the codes.

Steps:

• First, follow the first 2 steps from the first example to open the VBA window and insert a module.
• Then write the following codes–

Sub MoveDown_rowOffset()
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
End Sub

• Next, go back to your sheet.

• After that follow the sixth step from the first example to open the Macro dialog box.
• Then select the Macro name as mentioned in the codes and just press Run.

Soon after you will get the same output as in the first example.

Example 3. Embed VBA to Move Down One Cell from a Specific Cell

Now we’ll learn to move down from any specific cell as mentioned in the codes. Here, we’ll use Cell C4 as the specific cell. So our target is to move to Cell C5.

Steps:

• Follow the first 2 steps from the first example to open the VBA window and insert a module.
• Later, write the following codes–

Sub MoveDown_SpecificCell()
Range("C4").Offset(1, 0).Select
End Sub

• Then go back to your sheet.

Here, I mentioned the range which is C4 to move down from cell C4 to C5.

• Next, follow the sixth step from the first example to open the Macro dialog box.
• After that just select the macro name as mentioned in the codes and press Run.

Now have a look, we have successfully moved to Cell C5.

Example 4. Apply VBA to Move Down One Cell in a Filtered List

If we have filtered data then also we can move down to an active filtered cell using VBA. To show that I have filtered the Region column for the UK region. Now we’ll move to the first filtered Cell C7 from the active cell C4.

Steps:

• First, follow the first 2 steps from the first example to open the VBA window and insert a module.
• Later, write the following codes–

Sub MoveDown_FilteredList()
Range("C4").Select
ActiveCell.Offset(1, 0).Select
Do Until ActiveCell.EntireRow.Hidden = False
ActiveCell.Offset(1, 0).Select
Loop
End Sub

• Next, go back to your sheet.

• After that follow the sixth step from the first example to open the Macro dialog box.
• Then select the macro name as mentioned in the codes and just press Run.

Soon after Excel will move down to the filtered first Cell C7.

Practice Section

You will get a practice sheet in the Excel file given above to practice the explained ways.

learn how to move down one cell using Excel VBA with detailed explanations.

Download Practice Workbook

You can download the free Excel template from here and practice on your own.

Conclusion

I hope the procedures described above will be good enough to move down one cell using Excel VBA. Feel free to ask any question in the comment section and please give me feedback.

Related Articles

• How to Shift Cells Up in Excel
• How to Shift Cells Down in Excel without Changing Formula
• How to Shift Cells Right in Excel
• Fix: Excel Cannot Shift Nonblank Cells
• How to Tab to Certain Cells in Excel
• How to Perform Double Click Cell Jump in Excel
• Move One Cell to Right Using VBA in Excel

<< Go Back to Move Cells | Excel Cells | Learn Excel