How to Move One Cell Down Using Excel VBA (4 Methods)

The dataset represents the sales of various salespersons in different regions.


Method 1 – Using VBA to Move One Cell Down from an Active Cell

Steps:

  • Press Alt + F11 to open the VBA window.
  • Click to insert a new module: Insert ➤ Module.

Use VBA to Move Down One Cell from the Active Cell

  • Enter the following codes:
Sub MoveDown_ActiveCell()
ActiveCell.Offset(1).Select
End Sub
  • Go back to your sheet.

Use VBA to Move Down One Cell from the Active Cell

  • Activate a cell (i.e., cell C6).
  • Click 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.

The Macro has moved down to cell C7 from the active cell C6.

Read more: How to Shift Cells Down in Excel


Method 2 – Using VBA rowOffset

Steps:

  • Press Alt + F11 to open the VBA window.
  • Click to insert a new module: Insert ➤ Module.
  • Enter the following codes:
Sub MoveDown_rowOffset()
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
End Sub
  • Go back to your sheet.

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

  • Click to open the Macro dialog box: Developer ➤ Macros.
  • Select the Macro name as mentioned in the codes and press Run.

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

You will get the same output as in the first example.


Method 3 – Embedding VBA

Steps:

  • Press Alt + F11 to open the VBA window.
  • Click to insert a new module: Insert ➤ Module.
  • Enter the following codes:
Sub MoveDown_SpecificCell()
Range("C4").Offset(1, 0).Select
End Sub
  • Go back to your sheet.

Embed VBA to Move Down One Cell from a Specific Cell

  • Click to open the Macro dialog box: Developer ➤ Macros.
  • Select the macro name as mentioned in the codes and press Run.

Embed VBA to Move Down One Cell from a Specific Cell

You have successfully moved to Cell C5.


Method 4 – Applying VBA to Move One Cell Down in a Filtered List

Steps:

  • Press Alt + F11 to open the VBA window.
  • Click to insert a new module: Insert ➤ Module.
  • Enter 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
  • Go back to your sheet.

Apply VBA to Move Down One Cell in a Filtered List

Code Breakdown:

  • I created a Sub procedure MoveDown_FilteredList.
  • Then used Range(“C4”). Select Cell C4.
  • I used a Do Loop to skip every hidden row before the first filtered row.

  • Click to open the Macro dialog box: Developer ➤ Macros.
  • Select the macro name as mentioned in the codes and just press Run.

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 the Practice Workbook

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


Related Articles


<< Go Back to Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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