Md. Sourov Hossain Mithun
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 to 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.
4 Macros to Move Down One Cell Using Excel VBA
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: Move One Cell to Right Using VBA in Excel (3 Examples)
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.
Read more: How to Shift Cells Up in Excel (5 Quick Ways)
Similar Readings
- How to Move Highlighted Cells in Excel (5 Ways)
- Rearrange Rows in Excel (4 Ways)
- How to Shift Rows Down in Excel (3 Simple & Easy Ways)
- Move Rows in Excel (4 Simple & Quick Methods)
- How to Shift Cells Right in Excel (4 Quick Ways)
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.
Read More: How to Shift Data Up in Excel (3 Easiest Ways)
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.
Code Breakdown:
- First, I created a Sub procedure MoveDown_FilteredList.
- Then used Range(“C4”).Select to select Cell C4.
- Later, used a Do Loop to skip every hidden row before the first filtered row.
- 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.
Read more: How to Move Filtered Cells in Excel (3 Easy Methods)
Practice Section
You will get a practice sheet in the Excel file given above to practice the explained ways.
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.
