Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Move to the new cell, you need to use the Activate or Select method
Sub MyMacro()
         ' Change the top cell.
         ActiveCell.Value = "Top cell"
         ' Move down one cell.
         ActiveCell.Offset(1, 0).Select
         ' Now this changes the bottom cell.
         ActiveCell.Value = "Bottom cell"
     End Sub