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 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.

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

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.

Read more: How to Shift Cells Up in Excel (5 Quick Ways)


Similar Readings


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.

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.

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.

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.


Related Articles

Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo