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

Get FREE Advanced Excel Exercises with Solutions!

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.

Use VBA to Move Down One Cell from the Active Cell

  • Next, type the following codes in it-
Sub MoveDown_ActiveCell()
ActiveCell.Offset(1).Select
End Sub
  • After that go back to your sheet.

Use VBA to Move Down One Cell from the Active Cell

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

Use VBA to Move Down One Cell from the Active Cell

  • 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:

Sub MoveDown_rowOffset()
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
End Sub
  • Next, go back to your sheet.

Embed VBA to Move Down One Cell from the Active Cell Using rowOffset

Embed VBA to Move Down One Cell from the Active Cell Using rowOffset

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:

Sub MoveDown_SpecificCell()
Range("C4").Offset(1, 0).Select
End Sub
  • Then go back to your sheet.

Embed VBA to Move Down One Cell from a Specific Cell

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

Embed VBA to Move Down One Cell from a Specific Cell

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.

Apply VBA to Move Down One Cell in a Filtered List

Steps:

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.

Apply VBA to Move Down One Cell in a Filtered List

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.

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


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo