Move One Cell to Right Using VBA in Excel: 3 Methods

Method 1 – Move One Cell to Right Using Range Property

Steps:

  • Open the Developer tab. You can open it by pressing Alt+F11, or you can customize your ribbon section and get the Developer tab. This will open up the Visual Basic interface.

  • Go to the Insert tab and select Module.

  • A Module code window will occur. Copy the following code and paste it.
Sub VBA_range_offset()
Range("B5").Offset(0, 1).Select
End Sub
  • Close the Visual Basic code window.
  • Select cell B5.

Move One Cell to Right Using Range Property

  • Go to the View tab in the Ribbon and select Macros.

  • A Macro dialog box will appear. Select VBA_range_offset from the Macro Name and click on Run.

Move One Cell to Right Using Range Property

  • That will move your selection from cell B5 to cell C5.

Move One Cell to Right Using Range Property

Breakdown of the Code

Range(“B5”).Offset(0, 1).Select

Select a range from where you want to do your further work. Provide an offset property and specify the argument. Offset has two arguments, row and column. As we want to move one cell right, we keep the row value 0 and put the column value 1 to move one cell. Place different row and column arguments to shift to a different place.


Method 2 – Using ActiveCell Property

Steps:

  • The Developer tab by pressing Alt+F11.
  • Go to the Insert tab and select Module.

  • In the Module code window, copy the following code and paste it there.
Sub VBA_ActiveCell_offset()
ActiveCell.Offset(0, 1).Select
End Sub
  • Close the Module code window.
  • Select cell B6.

Move One Cell to Right Using ActiveCell Property

  • Go to the View tab and select Macros.

  • A Macro dialog box will appear. Select VBA_ActiveCell_offset from the Macro Name and click on Run.

Move One Cell to Right Using ActiveCell Property

  • That will move from cell B6 to cell C6.

Move One Cell to Right Using ActiveCell Property

Breakdown of the Code

ActiveCell.Offset(0, 1).Select

ActiveCell provides an option where you can select any cell from our worksheet. Offset has two arguments, row and column. As you want to move one cell right, so, we put row argument as 0 and column argument 1. This code will help to move any active cell in your worksheet and provide a dynamic offset.


Method 3 – Selection Property to Move One Cell to Right in Excel

Steps:

  • Open the Developer tab by pressing Alt+F11.
  • Go to the Insert tab and select Module.

  • In the Module Code window, copy the following code and paste it.
Sub VBA_selection_offset()

Selection.Offset(0, 1).Select

End Sub
  • Close the Module code window.
  • Select cell B8.

Selection Property to Move One Cell to Right in Excel

  • Go to the View tab in the ribbon and select Macros.

  • A Macro dialog box will appear. Select VBA_selection_offset from the Macro Name and click on Run.

Selection Property to Move One Cell to Right in Excel

  • This will shift one cell right from cell B8 to cell C8.

Breakdown of the Code

Selection.Offset(0, 1).Select

Two arguments of Offset help you to move one cell right. To do this, we put the row as 0 and column 1. Selection provides a dynamic situation where you can select any cell and apply this code; it will eventually move it to one cell right.


Download Practice Workbook

Download this practice workbook.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo